mysql数据库导出库中所有字段

select
DISTINCT(t.COLUMN_NAME),
t.COLUMN_TYPE,
t.DATA_TYPE,
t.column_comment from information_schema.COLUMNS t where t.TABLE_SCHEMA=‘test’;
select *from COLUMNS t where t.TABLE_SCHEMA=‘test’;