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’;
mysql数据库导出库中所有字段
最新推荐文章于 2024-06-28 16:34:54 发布
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’;