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;

本文出自 “梦想oO天堂” 博客，请务必保留此出处http://lionkas.blog.51cto.com/6265107/1859027

MySql查询数据字典的SQL语句