摘要：
查看表中字段的结构信息 可以用来查看表中字段的注释等，比如 select table_name,column_name,column_comment from information_schema.columns where table_schema ='表所在的库' and table_name 阅读全文
摘要：
SELECT B.TABLE_NAME AS '表名', C.COMMENTS AS '表说明', B.COLUMN_ID AS '字段序号', B.COLUMN_NAME AS '字段名', B.DATA_TYPE AS '字段数据类型', B.DATA_LENGTH AS '数据长度', B.D 阅读全文