数据库的字典数据类型导出

SELECT
	a.TABLE_SCHEMA "库名",
	a.TABLE_NAME "表名",
	a.COLUMN_NAME "列名",
	a.COLUMN_TYPE "类型",
	a.COLUMN_DEFAULT "默认值",
	a.IS_NULLABLE "是否为空",
	a.CHARACTER_SET_NAME "表字符集",
	a.COLLATION_NAME "校验字符集",
	CONCAT( a.COLUMN_COMMENT, a.COLUMN_KEY, a.EXTRA ) "列备注",
	b.TABLE_COMMENT "表备注",
	b.ENGINE "引擎" 
FROM
	information_schema.COLUMNS a,
	information_schema.TABLES b 
WHERE
	a.TABLE_SCHEMA = b.TABLE_SCHEMA 
	AND a.TABLE_SCHEMA IN ( 'databases1', 'databases2', 'databases2' ) 
	AND a.TABLE_NAME = b.TABLE_NAME 
ORDER BY
	a.TABLE_SCHEMA,
	a.TABLE_NAME,
	a.ORDINAL_POSITION