查询test数据库
SELECT t.TABLE_NAME,t.TABLE_COMMENT,c.COLUMN_NAME,c.COLUMN_TYPE,
c.COLUMN_COMMENT FROM information_schema.TABLES t,INFORMATION_SCHEMA.Columns c WHERE
c.TABLE_NAME=t.TABLE_NAME AND t.`TABLE_SCHEMA`='test'
查询test数据库
SELECT t.TABLE_NAME,t.TABLE_COMMENT,c.COLUMN_NAME,c.COLUMN_TYPE,
c.COLUMN_COMMENT FROM information_schema.TABLES t,INFORMATION_SCHEMA.Columns c WHERE
c.TABLE_NAME=t.TABLE_NAME AND t.`TABLE_SCHEMA`='test'