当前位置：网站首页>MYSQL导出数据字典

MYSQL导出数据字典

2022-08-08 04:18:00 【TomcatLikeYou】

字段导出:

SELECT
	TABLE_SCHEMA AS `数据库名`,
	TABLE_NAME AS `表名`,
	COLUMN_NAME AS `列名`,
	COLUMN_TYPE AS `类型`,
	COLUMN_DEFAULT AS `默认值`,
	IS_NULLABLE AS `允许为空`,
	DATA_TYPE AS `数据类型`,
	CHARACTER_MAXIMUM_LENGTH AS `字符最大长度`,
	NUMERIC_PRECISION AS `数字精度`,
	NUMERIC_SCALE AS `小数位数`,
	COLUMN_COMMENT AS `字段说明` 
FROM
	information_schema.COLUMNS 
WHERE
	TABLE_SCHEMA = 'db_name' #db_name代表数据库名

表导出

SELECT
	TABLE_SCHEMA AS `数据库名`,
	TABLE_NAME AS `表名`,
	CREATE_TIME AS `创建时间`,
	TABLE_COLLATION AS `字符集`,
	TABLE_COMMENT AS `表注释` 
FROM
	information_schema.TABLES
WHERE
	TABLE_SCHEMA = 'db_name'

视图导出

SELECT
	TABLE_SCHEMA AS `数据库名`,
	TABLE_NAME AS `视图名`
FROM
	information_schema.VIEWS 
WHERE
	TABLE_SCHEMA = 'db_name'

版权声明
本文为[TomcatLikeYou]所创，转载请带上原文链接，感谢
https://blog.csdn.net/qq_37293230/article/details/126105003

边栏推荐

猜你喜欢

随机推荐