05 2013 档案

mysql显示所有foreign key
摘要：selectconcat(table_name,'.',column_name)as'foreignkey',concat(referenced_table_name,'.',referenced_column_name)as'references'frominformation_schema.key_column_usagewheretable_schema='project'andreferenced_table_nameisnotnull;selectconcat(table_name,'.' 阅读全文
posted @ 2013-05-01 14:05 赵治鲁 阅读(355) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示