【MySQL】MySQL运维SQL（持续更新。。。）

MySQL运维SQL

信息统计

查询数据库有多少张表

SELECT COUNT(*) AS table_count FROM information_schema.TABLES WHERE table_schema = '数据库名';

查询表中有多少个字段

SELECT
	COUNT(*) AS field_count 
FROM
	information_schema.COLUMNS 
WHERE
	table_schema = '数据库名' 
	AND table_name = '表名';

查询表中有哪些非空约束字段

SELECT COLUMN_NAME   
FROM INFORMATION_SCHEMA.COLUMNS   
WHERE TABLE_SCHEMA = '数据库名'   
  AND TABLE_NAME = '表名'   
  AND IS_NULLABLE = 'NO';