select TABLE_NAME,column_name,column_type,COLUMN_COMMENT from information_schema.COLUMNS
where
TABLE_SCHEMA=’zdtq_patent’;
select * from information_schema.COLUMNS
where
TABLE_SCHEMA=’zdtq_patent’;
use information_schema;
select * from TABLES where TABLE_SCHEMA=’my_db’;
use information_schema;
select a.TABLE_NAME,a.table_comment,b.COLUMN_NAME,b.column_type,b.COLUMN_COMMENT from TABLES a,information_schema.COLUMNS
b where a.TABLE_SCHEMA=’zdtq_patent’ and a.table_name=b.TABLE_NAME