且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在MySQL数据库的每个表中搜索所有字段

更新时间: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.