得到指定的库对应的全部表名和列名以及他们的注释sql
SELECT b.table_name AS "表名称", b.Table_comment AS "表注释", a.column_name AS "字段名称",a.data_type AS '数据类型', a.column_comment AS "字段注释" FROM ( SELECT column_name, Table_name, column_comment, table_schema,data_type FROM information_schema.columns WHERE table_schema = "这里输入要查询的库的名称" ) a LEFT JOIN ( SELECT table_name, Table_comment, table_schema FROM information_schema.tables ) b ON a.Table_name = b.table_name AND a.table_schema = b.table_schema