mysql数据库information_schema，表信息，字段信息，权限信息等

PS：应返回数据可能较多，加上where条件，或者limit返回条数。

• 查询库中所有表信息，可以增加条件筛选

select * from information_schema.tables where table_schema='lizz_db';

• 查询库中所有字段信息，可以增加条件筛选

select * from information_schema.columns where  table_schema='lizz_db';

• 数据库实例中数据库信息

select * from information_schema.SCHEMATA;

• 索引信息

select * from information_schema.STATISTICS where table_schema='lizz_db';

• 用户权限

select * from information_schema.USER_PRIVILEGES limit 10;

• 库权限

select * from information_schema.SCHEMA_PRIVILEGES limit 100;

• 表权限

select * from information_schema.TABLE_PRIVILEGES limit 100;

• 字段权限

select * from information_schema.COLUMN_PRIVILEGES limit 100;

• 字符集

select * from information_schema.CHARACTER_SETS;

• 字符集对照表

select * from information_schema.COLLATIONS limit 100;

• 表约束信息，如主键，唯一键等。

select * from information_schema.TABLE_CONSTRAINTS where table_schema='lizz_db';

• 约束字段信息，如id

select * from information_schema.KEY_COLUMN_USAGE where table_schema='lizz_db';

• 程序信息，如存储过程，方法函数等

select * from information_schema.ROUTINES where ROUTINE_SCHEMA='lizz_db';

• 试图信息

select * from information_schema.VIEWS where table_schema='lizz_db';

• 触发器信息

select * from information_schema.TRIGGERS limit 10;