mysql 查询数据字典

SELECT c.TABLE_SCHEMA AS 库名,
c.TABLE_NAME AS 表名,
t.TABLE_COMMENT 表说明,
c.COLUMN_NAME AS 字段名,
c.COLUMN_TYPE AS 数据类型,
c.IS_NULLABLE AS 是否允许为空,
c.COLUMN_COMMENT AS 字段说明 
FROM information_schema.COLUMNS c inner join information_schema.tables t on  t.`table_name`=c.table_name
WHERE c.TABLE_SCHEMA='sjk'