导出表结构 字段说明

select a.TABLE_SCHEMA,a.table_name,b.COLUMN_NAME,b.COLUMN_TYPE,b.COLUMN_COMMENT from information_schema.tables a,information_schema.COLUMNS b
where a.TABLE_NAME=b.TABLE_NAME
and a.TABLE_SCHEMA like 'gwtrip_%'