MySQL查询包含指定字段的表
查询包含指定字段的表SELECT DISTINCT TABLE_NAME FROM information_schema.COLUMNS WHERE COLUMN_NAME = 'cloumnname' AND TABLE_SCHEMA='tablename';查询当前数据库的所有表SELECT table_name FROM information_schema.TABLES ...
·
查询包含指定字段的表
SELECT DISTINCT TABLE_NAME FROM information_schema.COLUMNS WHERE COLUMN_NAME = 'cloumnname' AND TABLE_SCHEMA='tablename';
查询当前数据库的所有表
SELECT table_name FROM information_schema.TABLES WHERE table_schema='tablename' AND table_type='base table';
更多推荐
已为社区贡献4条内容
所有评论(0)