MYSQL：筛选数据库的字段，查询字段和相关属性

小豆丁 1年前 ⋅ 127 阅读 
SELECT

TABLE_SCHEMA AS '库名',

TABLE_NAME AS '表名',

COLUMN_NAME AS '列名',

COLUMN_TYPE AS '列类型',

ORDINAL_POSITION AS '列的排列顺序',

COLUMN_DEFAULT AS '默认值',

IS_NULLABLE AS '是否为空',

DATA_TYPE AS '数据类型',

CHARACTER_MAXIMUM_LENGTH AS '字符最大长度',

NUMERIC_PRECISION AS '数值精度(最大位数)',

NUMERIC_SCALE AS '小数精度',


COLUMN_KEY 'KEY',

EXTRA AS '额外说明',

COLUMN_COMMENT AS '注释'

FROM

information_schema.`COLUMNS`

WHERE

(TABLE_SCHEMA = 'test1' or TABLE_SCHEMA = 'test2') and COLUMN_TYPE = 'tinyint(1)'

ORDER BY

TABLE_NAME,

ORDINAL_POSITION;

注意：本文归作者所有，未经作者允许，不得转载

#sql

全部评论: 0 条

    我有话说: