mysql库信息展示
2018-09-07 本文已影响0人
炒面Z
展示所有表名/注释
select table_name,table_comment from information_schema.tables where table_schema = database();
image.png
展示单个表里所有字段信息
select COLUMN_NAME, COLUMN_COMMENT,COLUMN_DEFAULT,IS_NULLABLE,COLUMN_TYPE,COLUMN_KEY,EXTRA from information_schema.columns where table_schema =database() and table_name = '<table_name>';
image.png
索引
show keys from <table_name>;
image.png
