MYSQL生成数据库字典

SELECT
  TABLE_NAME AS '表名',
  COLUMN_NAME AS '列名',
  COLUMN_TYPE AS '数据类型',
  IS_NULLABLE AS '允许空值',
  COLUMN_DEFAULT AS '默认值',
  COLUMN_COMMENT AS '列描述'
FROM
  INFORMATION_SCHEMA.COLUMNS
WHERE
  TABLE_SCHEMA = 'longkong'
ORDER BY
  TABLE_NAME,
  ORDINAL_POSITION;