Querying the database for all tables and fields and their comments (MySQL)

#查询某个库所有表select * from INFORMATION_SCHEMA. Tableswhere table_schema = ' database ' #查询某个库所有表的字段select * from INFORMATION_SCHEMA. Columnswhere table_schema = ' database ' #查询所有表的注释和字段注释SELECTa. table_name table name, a.table_comment table description, b.column_name field name, B.column_ Comment Field description, b.column_type field type, B.column_key constraint Frominformation_schema. TABLES aleft JOIN information_schema. COLUMNS b on a.table_name = B.table_namewherea.table_schema = ' database ' ORDER bya.table_name

Querying the database for all tables and fields and their comments (MySQL)