不常用sql - wolai 笔记

查询包含特定列名的表

-- table_name='查询表名称' and table_schema='数据库名称'

select table_schema,table_name,column_name,column_comment,data_type

from information_schema.columns

where column_name like '%bank%'

查询当前正在执行的sql

SELECT
  * 
FROM
  information_schema.`PROCESSLIST` 
WHERE
  command != 'sleep' 
  AND info IS NOT NULL 
ORDER BY
  time DESC

#当前连接数
SHOW FULL PROCESSLIST;
#最大连接数
SHOW VARIABLES LIKE '%max_connections%';