mysql 导出数据字典

 

SELECT
TABLE_CATALOG,
TABLE_SCHEMA as 数据库名,
TABLE_NAME as 表名,
COLUMN_NAME as 字段名,
ORDINAL_POSITION as 字段位置,
COLUMN_DEFAULT as 字段默认值,
IS_NULLABLE 是否允许空值,
DATA_TYPE as 数据类型,
CHARACTER_MAXIMUM_LENGTH as 以字符为单位的最大长度,
CHARACTER_OCTET_LENGTH as 以字节为单位的最大长度,
NUMERIC_PRECISION as 数值类型的长度,
NUMERIC_SCALE as 小数点精度,
DATETIME_PRECISION as 回的日期时间值的精度,
CHARACTER_SET_NAME as 编码方式,
COLLATION_NAME as 校对集,
COLUMN_TYPE as 字段类型,
COLUMN_KEY as 键,
EXTRA as 额外的信息例如自动递增在这里显示,
PRIVILEGES as 权限,
COLUMN_COMMENT as 字段注释,
GENERATION_EXPRESSION
FROM
    information_schema. COLUMNS
WHERE
    TABLE_SCHEMA = 'Testplatform'

 

　　

 

 

 

SELECT
TABLE_SCHEMA,
TABLE_NAME,
COLUMN_NAME,
COLUMN_TYPE,
COLUMN_COMMENT
FROM
information_schema. COLUMNS
WHERE
TABLE_SCHEMA = '数据库名称'

 

 

 

SELECT
TABLE_SCHEMA,
TABLE_NAME AS '表名',
COLUMN_NAME AS '字段名',
COLUMN_TYPE AS '数据类型',
IS_NULLABLE AS '允许为空',
EXTRA AS '额外信息',
COLUMN_COMMENT AS '字段说明'
FROM
information_schema.`COLUMNS`
WHERE
TABLE_SCHEMA = 'Testplatform'