mysql导出数据字典_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'