徐冬丽 发表于 2016-10-21 08:13:05

mysql中列出所有表格的对应字段

SELECT TABLE_NAME,COLUMN_NAME FROM information_schema.key_column_usage where CONSTRAINT_SCHEMA='tablename' and CONSTRAINT_NAME='PRIMARY'
http://img.zemanta.com/pixy.gif?x-id=f70b0f99-c60d-8d14-ba7f-28f3f74ac26e
页: [1]
查看完整版本: mysql中列出所有表格的对应字段