Nesting SHOW TABLE STATUS

Using MySQL’s “SHOW TABLE STATUS” within other select statements requires pulling this information from the information_schema database. If you where to run this sql statement:

SELECT * FROM (SHOW TABLE STATUS FROM db_name)

MySQL will return a syntax error. Try this method instead for the same result:

SELECT * FROM (
SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=’db_name’
AND TABLE_NAME=’tbl_name’)