SELECT * FROM information_schema.columns WHERE column_name like ‘%teaching_center_id%‘ and TABLE_SCHEMA="zykydb_modify" ORDER BY Table_name asc;
查找数据库相关联的列名。
SELECT * FROM information_schema.INNODB_SYS_INDEXES WHERE `NAME` like ‘%class%‘
查找数据库相关联的索引
SELECT * FROM information_schema.columns WHERE COLUMN_COMMENT like ‘%,%‘ and TABLE_SCHEMA="zykydb_modify" ORDER BY Table_name asc;
查找数据库相关的备注