1. information_schema.COLUMNS 表记录了所有库中所有表的字段信息
SELECT
COLUMN_NAME 字段名称,
COLUMN_TYPE 字段类型,
COLUMN_DEFAULT 默认值,
CHARACTER_MAXIMUM_LENGTH AS 最大长度,
- (
- CASE
- WHEN is_nullable = 'NO' THEN
- '否'
- ELSE
- '是'
- END
) AS 是否可空,
- (
- CASE
- WHEN column_key = 'PRI' THEN
- '是'
- ELSE
- '否'
- END
) AS 是否主键,
COLUMN_COMMENT 描述
- FROM
- INFORMATION_SCHEMA. COLUMNS
- WHERE
- table_schema = 'simulation_platform'
- AND table_name = 'task'
- ----------------
来源: http://www.bubuko.com/infodetail-3384664.html