SELECT COLUMN_NAME,column_comment,Table_NAME FROM INFORMATION_SCHEMA.Columns WHERE table_schema='数据库名' AND column_comment LIKE '%代课%';
通过注释查找字段和表名
最新推荐文章于 2022-08-17 14:03:16 发布
SELECT COLUMN_NAME,column_comment,Table_NAME FROM INFORMATION_SCHEMA.Columns WHERE table_schema='数据库名' AND column_comment LIKE '%代课%';