sql语句
select table_schema , table_name , table_rows , table_comment ,
(select GROUP_CONCAT(COLUMN_NAME) from information_schema.columns a where table_schema ='wdl_base' and a.table_name = b.table_name) COLUMN_NAME ,
(select REPLACE(GROUP_CONCAT(column_comment),',,','') from information_schema.columns a where table_schema ='wdl_base'
and a.table_name = b.table_name) column_comment
from information_schema.tables b where table_schema='wdl_base' and table_type='base table';