MySQL queries the table based on the field name

MySQL needs to query the table where the field name is located based on a field name. This is mainly because, for example, you forget the table name, you only know that there is such a field name, and you want to find the table. The second case may be that the same field name belongs to a foreign key. You want to find out how many tables have this field, for example, id.

In Versions later than MySQL 5.0, you can use the columns table in the information_schema database to complete the following steps:CodeTo achieve:

UseInformation_schema;
Select * FromColumnsWhereColumn_name='Field name';