1、查看所有进程
show processlist;
2、所有进程查询生成杀掉进程的命令
select concat('KILL ',id,';') from information_schema.processlist WHERE time >100;
3、查询数据库所有表名和注释生成添加语句
SELECT concat('ALTER TABLE ',tableName,'COMMENT=',"'" ,tableComment,"'") FROM (
SELECT
TABLE_NAME AS tableName,
TABLE_COMMENT AS tableComment
FROM
information_schema.`TABLES`
WHERE
TABLE_SCHEMA = 'digital_potal') t