1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

SELECT
COLUMN_KEY 主键,
COLUMN_NAME 列名,
COLUMN_TYPE 数据类型,
COLUMN_COMMENT 注释,
IS_NULLABLE 是否可空
FROM
information_schema.`COLUMNS`
WHERE
TABLE_SCHEMA='cgdb20210701'
AND
table_name='iot_equip_follow'