SELECT TABLE_NAME AS ‘表名’, COLUMN_NAME AS ‘字段名’, COLUMN_TYPE AS ‘数据类型’, IS_NULLABLE AS ‘允许为空’, EXTRA AS ‘PK’, COLUMN_COMMENT AS ‘字段说明’ FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '数据库名称
导出数据库字典SELECTTABLE_NAME AS ‘表名’,COLUMN_NAME AS ‘字段名’,COLUMN_TYPE AS ‘数据类型’,IS_NULLABLE AS ‘允许为空’,EXTRA AS ‘PK’,COLUMN_COMMENT AS ‘字段说明’FROMinformation_schema.COLUMNSWHERETABLE_SCHEMA = '数据库名称...