SELECT
COLUMN_NAME AS 列名,
COLUMN_TYPE AS 数据类型(精度范围),
DATA_TYPE AS 字段类型,
CHARACTER_MAXIMUM_LENGTH AS 长度,
IS_NULLABLE AS 是否非空,
COLUMN_COMMENT AS 名称,
COLUMN_DEFAULT AS 默认值
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
-- 数据库名
TABLE_SCHEMA = 'palmtengchong'
AND
-- 表名
TABLE_NAME = 'tc_bus_manage';