为了使用navicat导出word文档所写的mysql语句:
SELECT
COLUMN_NAME 代码,
COLUMN_COMMENT 名称,
COLUMN_TYPE 数据类型,
'false' as 是键,
COLUMN_COMMENT 注释
FROM
INFORMATION_SCHEMA.COLUMNS
where
table_schema ='csp'
AND
table_name = 'csp_user'
为了使用navicat导出word文档所写的mysql语句:
SELECT
COLUMN_NAME 代码,
COLUMN_COMMENT 名称,
COLUMN_TYPE 数据类型,
'false' as 是键,
COLUMN_COMMENT 注释
FROM
INFORMATION_SCHEMA.COLUMNS
where
table_schema ='csp'
AND
table_name = 'csp_user'