常用语句
SELECT
COLUMN_NAME 列名,
COLUMN_TYPE 数据类型,
COLUMN_KEY 索引,
IS_NULLABLE 是否允许为空,
COLUMN_DEFAULT 默认值,
COLUMN_COMMENT 注释
FROM
information_schema.`COLUMNS`
WHERE
TABLE_SCHEMA='库名'
AND
table_name='表名'
参考博客
[1]https://blog.csdn.net/cxh6863/article/details/84499255
[2]https://blog.csdn.net/maquealone/article/details/60764420