查询数据库中全部表名称的语句
SELECT table_name, table_type, engine
FROM information_schema.tables
WHERE table_schema = '数据库名称'
ORDER BY table_name DESC;
查找mysql数据库中全部包含特定名字的字段所在的表
select * from INFORMATION_SCHEMA.columns
where COLUMN_NAME Like '%placement%';html
查询数据库中全部表名称的语句
SELECT table_name, table_type, engine
FROM information_schema.tables
WHERE table_schema = '数据库名称'
ORDER BY table_name DESC;
查找mysql数据库中全部包含特定名字的字段所在的表
select * from INFORMATION_SCHEMA.columns
where COLUMN_NAME Like '%placement%';html
转载于:https://www.cnblogs.com/super-admin/p/10075036.htmlmysql