Laurent Hinoul

“Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.” - John F. Woods

How to find a column name in all tables in MySQL

Sometimes, it could be handy to know in which tables a certain column name is specified. To do so, use the query below.

Note: you need to fill in your own column names and table_schema. Enjoy!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: