MySql查询数据字典的SQL语句

Select

r.TABLE_COMMENT,

t.TABLE_NAME,

t.COLUMN_NAME,

t.COLUMN_COMMENT,

t.DATA_TYPE,

t.COLUMN_TYPE,

t.IS_NULLABLE,

t.COLUMN_DEFAULT,

t.COLUMN_KEY,

t.EXTRA

FROM

information_schema.`COLUMNS` t,

information_schema.`TABLES` r

WHERE

t.TABLE_NAME LIKE 'pre_%'

AND t.TABLE_SCHEMA = 'db_zhangwoo'

AND t.TABLE_NAME = r.TABLE_NAME;

转载于:https://blog.51cto.com/lionkas/1859027