select GROUP_CONCAT(column_name) as column_name,GROUP_CONCAT(data_type) as data_type
from information_schema.columns
where table_name='d_area' and table_schema='house'
或
select GROUP_CONCAT("`",column_name,"`") as column_name,GROUP_CONCAT(data_type) as data_type
from information_schema.columns
where table_name='表名' and table_schema='库名'