导出Mysql数据库数据字典的语句
SELECT tmp.TABLE_SCHEMA AS 库名,
tmp.TABLE_NAME AS 表名,
tmp.COLUMN_NAME AS 字段名,
tmp.COLUMN_TYPE AS 数据类型,
CASE IFNULL(tmp.COLUMN_DEFAULT,‘Null’)
WHEN ‘’ THEN ‘空字符串’
WHEN ‘Null’ THEN ‘NULL’
ELSE tmp.COLUMN_DEFAULT END AS 默认值,
CASE tmp.IS_NULLABLE
WHEN ‘YES’ THEN ‘是’
ELSE ‘否’ END AS 是否允许为空,
tmp.COLUMN_COMMENT AS 字段说明
FROM information_schema.COLUMNS tmp
WHERE tmp.TABLE_SCHEMA=‘test’ and tmp.TABLE_NAME =‘name’;
其中test为库名,name为表名。