SELECT COLUMN_NAME,column_comment,Table_NAME FROM INFORMATION_SCHEMA.Columns WHERE table_schema='数据库名' AND column_comment LIKE '%代课%';
通过注释查找字段和表名
最新推荐文章于 2023-04-06 19:38:48 发布
SELECT COLUMN_NAME,column_comment,Table_NAME FROM INFORMATION_SCHEMA.Columns WHERE table_schema='数据库名' AND column_comment LIKE '%代课%';