查看MySQL 字段KEY值---PRI, UNI, MUL
摘要：sql语句 1 select column_key 2 from information_schema.columns 3 where table_schema='数据库名称' and table_name='数据表名称' and column_name='字段名'; 返回值为： PRI >主键约束
阅读全文
posted @
2021-07-01 17:23
viaviaYeyuan
阅读(909)
推荐(0) 编辑
mysql数据库表结构导出到Excel中——利用HeidiSQL
摘要：直接上sql select column_name as 字段, column_type as 数据类型, data_type as 字段类型, character_maximum_length as 长度, is_nullable as 是否为空, column_default as 默认值, c
阅读全文
posted @
2021-06-30 23:01
viaviaYeyuan
阅读(3083)
推荐(0) 编辑
