Finding the table containing a column name in MySQL

Published on 2013-09-25 by John Collins. Socials: YouTube - X - Spotify - Amazon Music - Apple Podcast

Sometimes when you are working with a legacy database schema that you are unfamiliar with, you are confronted with column names in error messages but not the table name that contains the column in question. An example of this is the 1048 error in MySQL, where some code has attempted to write a record to the database with a null value for a column that contains a NOT NULL constraint:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ColumnName' cannot be null

Great, but what table contains the column "ColumnName"? Answering that question can be particularly hard if there are many tables in the database schema.

Luckily you can query the MySQL meta data to find out:

    AND TABLE_SCHEMA='DatabaseName';

Updated 2023 : note that the above post was originally published in 2013 and may be outdated, but is left here for archival purposes.