名称中有'%user%'的表
select table_name from information_schema.tables where table_schema='neimenggu_new2' and table_name like '%user%'
有'user'字段的表
select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME from information_schema.columns where column_name like 'user'
名称中有'%user%'的表
select table_name from information_schema.tables where table_schema='neimenggu_new2' and table_name like '%user%'
有'user'字段的表
select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME from information_schema.columns where column_name like 'user'
转载于:https://www.cnblogs.com/yifanSJ/p/9176389.html