information_schema（information_schema.schemata）

select * from information_schema.processlist where command = 'query';

SELECT * FROM information_schema.triggers WHERE TRIGGER_NAME='trig1'G

SHOW TRIGGERSG

Seconds - Behind - Master值查看主从延迟

#MySQL字典#

SELECT

a.TABLE_SCHEMA AS '数据库名称',

a.TABLE_NAME AS '表名',

b.TABLE_COMMENT AS '表说明',

a.COLUMN_NAME AS '字段名',

a.ORDINAL_POSITION AS '字段编号',

a.COLUMN_DEFAULT AS '字段默认值',

a.IS_NULLABLE AS '允许为空',

a.COLUMN_TYPE AS '数据类型',

a.COLUMN_COMMENT AS '字段说明'

FROM

information_schema.COLUMNS a

LEFT JOIN information_schema.TABLES b>