I have 2-3 different column names that I want to look up in the entire database and list out all tables which have those columns. Is there any easy script?
Mysql – How to find all the tables in MySQL with specific column names in them
information-schemaMySQL
Related Topic
- Mysql – Which MySQL data type to use for storing boolean values
- Mysql – How to output MySQL query results in CSV format
- Php – How to do ‘insert if not exists’ in MySQL
- Mysql – Truncate all tables in a MySQL database in one command
- MySQL DROP all tables, ignoring foreign keys
- Mysql – How to get all columns’ names for all the tables in MySQL
- Mysql – How to get the sizes of the tables of a MySQL database
- Mysql – How to import an SQL file using the command line in MySQL
Best Answer
To get all tables with columns
columnA
orColumnB
in the databaseYourDatabase
: