MYSQL queries table and field names from a number of tables

Select * from table where id = 1; select * from table where id = 1;

SELECT table_name, column_name from information_schema.columns WHERE column_name LIKE ‘Name’;

It can also be found in the following two ways:

SELECT column_name from information_schema.columns WHERE column_name LIKE ‘%searchTerm%’ AND table_schema = ‘yourDB’

SELECT column_name from information_schema.columns WHERE column_name LIKE ‘%searchTerm%’ AND table_schema = ‘yourDB’ AND Table_name = ‘yourDBTable’

That way, we won’t be at a loss when so many watches suddenly appear.