SELECT
COLUMN_NAME 列名,
COLUMN_TYPE 类型,
COLUMN_COMMENT 说明
FROM
INFORMATION_SCHEMA.COLUMNS
where
table_schema ='xx'
AND
table_name = 'xx'
mysql数据表结构转doc设计文档sql语句
最新推荐文章于 2024-01-03 16:32:49 发布
SELECT
COLUMN_NAME 列名,
COLUMN_TYPE 类型,
COLUMN_COMMENT 说明
FROM
INFORMATION_SCHEMA.COLUMNS
where
table_schema ='xx'
AND
table_name = 'xx'