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