SELECT
column_name AS '字段名称',
column_type AS '字段类型',
column_comment AS '字段描述',
IF(column_key='PRI','TRUE','FALSE') AS '主键唯一',
IF(IS_NULLABLE='NO','TRUE','FALSE') AS '非空'
FROM
information_schema. COLUMNS
WHERE
TABLE_SCHEMA = '库名称'
AND column_type like '%VARCHAR%%';