Cacher is the code snippet organizer for pro developers

SHOW TABLE STATUS FROM <database_name>;

SHOW TABLE STATUS WHERE name = "<table_name>" \G;

SHOW TABLE STATUS FROM <database_name> where name = "<table_name>";