MySQL SHOW TABLE STATUS

MySQL SHOW TABLE STATUS is a SQL statement in the MySQL Specific category. MySQL: shows detailed information about tables including engine, row count, data size, and collation. The syntax is SHOW TABLE STATUS LIKE 'pattern';. It returns table status. A typical example: SHOW TABLE STATUS FROM my_database LIKE 'employees'\G; -- Name: employees -- Engine: InnoDB -- Row_format: Dynamic -- Rows: 1050 -- Avg_row_length: 98 -- Data_length: 524288 -- Max_data_length: 0 -- Index_length: 163840 -- Data_free: 4194304 -- Auto_increment: 1100 -- Create_time: 2026-01-15 10:30:00 -- Collation: utf8mb4_unicode_ci -- Find largest tables: SELECT TABLE_NAME, (DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 AS size_mb FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'my_database' ORDER BY size_mb DESC; A close relative is AUTO_INCREMENT, which mySQL auto-generates sequential integer values for this column. Commonly used with PRIMARY KEY. A close relative is ENGINE, which specifies the MySQL storage engine. InnoDB (default) supports transactions and foreign keys. MyISAM is faster for read-heavy.