sql常用语句

查找某个表在那个库

SELECT table_schema FROM information_schema.TABLES WHERE table_name = '表名';

查找某个字段在那个表

SELECT * FROM information_schema.columns WHERE column_name='column_name';

查看当前连接数

SHOW STATUS LIKE 'Threads%'

查看当前所有链接用户

SHOW FULL PROCESSLIST;