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