淘先锋技术网

首页 1 2 3 4 5 6 7

1、使用navicat 工具执行以下sql

SELECT 
COLUMN_NAME AS 字段名称, 
COLUMN_TYPE AS 类型 ,
(CASE WHEN  IS_NULLABLE = 'YES' THEN '是' ELSE '否' END) AS 是否为空,
COLUMN_COMMENT AS 备注 
FROM information_schema.`COLUMNS`   
WHERE  TABLE_SCHEMA = (select database()) AND  TABLE_NAME = ('sys_public_param')
ORDER BY  ORDINAL_POSITION;

2、在word中建好表格,复制执行的内容粘贴到word表格中