Mysql查询表字段的内容
SELECT table_name'表名',COLUMN_COMMENT AS '列名中文',Column_NameAS 列名英文,data_type AS 数据类型,(CASEWHEN data_type = 'float'OR data_type = 'double'OR data_type = 'TINYINT'OR data_type = 'SMALLINT'OR data_type = 'MEDIUMINT'OR data_type = 'INT'OR data_type = 'INTEGER'OR data_type = 'decimal'OR data_type = 'bigint'THENNUMERIC_PRECISIONELSECHARACTER_MAXIMUM_LENGTHEND) AS '长度(整数)',NUMERIC_SCALE AS '长度(小数)',(CASEWHEN EXTRA = 'auto_increment' THEN1ELSE0END) AS '是否自增',(CASEWHEN IS_NULLABLE = 'NO' THEN0ELSE1END) AS '能否为空',(CASEWHEN COLUMN_KEY = 'PRI' THEN1ELSE0END) AS '是否是主键',# extra,COLUMN_DEFAULT AS '默认值'FROM information_schema.COLUMNSwhere table_schema = '表名' #表所在数据库
下面列举出所有字段信息:
正在整理成工具,在线查看所有的结构,可以导出PDF和Excel等格式,以后回开源出来……