本节主要内容:
select语句查询表的字段属性及注释内容
sql语句:
复制代码 代码示例:
SELECT
column_name AS `列名`,
data_type AS `数据类型`,
character_maximum_length AS `字符长度`,
numeric_precision AS `数字长度`,
numeric_scale AS `小数位数`,
is_nullable AS `是否允许非空`,
CASE WHEN extra = 'auto_increment'
THEN 1 ELSE 0 END AS `是否自增`,
column_default AS `默认值`,
column_comment AS `备注`
FROM
Information_schema.columns
WHERE
table_Name='mytable_name';
代码说明:
查询Information_schema.columns中的信息,以获取table_Name='mytable_name';表的字段属性与注释内容。
修改select查询指定的表名即可,有兴趣的朋友可以亲测一下。