读取mysql数据库表格中的字段和字段注解需要用到如下的语句:
--------------------------------------------------------------------------------------------- 想要返回其他的信息,可使用 SELECT * ,结果中包含了表格字段的全部信息,比如字段类型、是否为空、主键、默认值等等,总有你想要的。
----------------------------------------------------------------------------------------------- 如果你还嫌信息不够详细,不够多可以自己去INFORMATION_SCHEMA数据库里面去找,下面是这个数据库的全部表格: mysql> use information_schema; Database changed mysql> show tables; +---------------------------------------+ | Tables_in_information_schema | +---------------------------------------+ | CHARACTER_SETS | | COLLATIONS | | COLLATION_CHARACTER_SET_APPLICABILITY | | COLUMNS | | COLUMN_PRIVILEGES | | ENGINES | | EVENTS | | FILES | | GLOBAL_STATUS | | GLOBAL_VARIABLES | | KEY_COLUMN_USAGE | | PARTITIONS | | PLUGINS | | PROCESSLIST | | PROFILING | | REFERENTIAL_CONSTRAINTS | | ROUTINES | | SCHEMATA | | SCHEMA_PRIVILEGES | | SESSION_STATUS | | SESSION_VARIABLES | | STATISTICS | | TABLES | | TABLE_CONSTRAINTS | | TABLE_PRIVILEGES | | TRIGGERS | | USER_PRIVILEGES | | VIEWS | +---------------------------------------+ 28 rows in set ------------------------------------------------------------------------------------------------ 另外,如果只想得到字段名、类型、主键、默认值等结构信息,可以使用: DESCRIBE 'tablename'--//查询表结构 SHOW COLUMNS FROM 'tablename' WHERE `NULL`='NO' --//筛选出不为空的字段 DESC 'tablename' 'i%'--//只查看以i开通的字段结构 |