SELECT
TABLE_NAME 表名,
COLUMN_NAME 列名,
COLUMN_TYPE 数据类型,
DATA_TYPE 字段类型,
CHARACTER_MAXIMUM_LENGTH 长度,
IS_NULLABLE 是否为空,
COLUMN_DEFAULT 默认值,
COLUMN_COMMENT 备注,
(CASE COLUMN_KEY WHEN 'PRI' THEN 'true' ELSE '' END) AS '主键'
FROM
INFORMATION_SCHEMA.COLUMNS
where
table_schema ='bpm_aqsk_test'
AND
table_name = 'hotwork_ticket'
01-21
1129
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
05-13
2122
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
06-27
1万+
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
08-23