更新时间:2023-10-08 08:24:40
您可以查看information_schema
模式.它具有所有表和表中所有字段的列表.然后,您可以使用从该表获得的信息来运行查询.
You can peek into the information_schema
schema. It has a list of all tables and all fields that are in a table. You can then run queries using the information that you have gotten from this table.
涉及的表是SCHEMATA,TABLES和COLUMNS.有一些外键,使您可以准确地建立在模式中创建表的方式.
The tables involved are SCHEMATA, TABLES and COLUMNS. There are foreign keys such that you can build up exactly how the tables are created in a schema.