select TABLE_SCHEMA as '数据库',TABLE_NAME as '数据表',COLUMN_NAME as '字段名',COLUMN_TYPE as '字段类型',COLUMN_COMMENT as '备注' from information_schema.columns where TABLE_SCHEMA='数据库名' ;
MYSQL 查询语句:select TABLE_SCHEMA as '数据库',TABLE_NAME as '数据表',COLUMN_NAME as '字段名',COLUMN_TYPE as '字段类型',COLUMN_COMMENT as '备注' from information_schema.columns where TABLE_SCHEMA='数据库名' ;利用Navicat ...