MySQL基础查询语句
1、查询指定数据库中所有主外键关系
select concat(table_name, '.', column_name) as 'foreign key', concat(referenced_table_name, '.', referenced_column_name) as 'references' from information_schema.key_column_usage where table_schema='redmine' and referenced_table_name is not null;
select concat(table_name, '.', column_name) as 'foreign key', concat(referenced_table_name, '.', referenced_column_name) as 'references' from information_schema.key_column_usage where table_schema='redmine' and referenced_table_name is not null;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22558114/viewspace-1591375/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
