Syntax:
CHECK TABLE tbl_name [, tbl_name] ... [option] ...

option = {FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED}

CHECK TABLE checks a table or tables for errors. CHECK TABLE works for
MyISAM, InnoDB, and ARCHIVE tables. Starting with MySQL 5.1.9, CHECK
TABLE is also valid for CSV tables, see
http://dev.mysql.com/doc/refman/5.1/en/csv-storage-engine.html. For
MyISAM tables, the key statistics are updated as well.

CHECK TABLE can also check views for problems, such as tables that are
referenced in the view definition that no longer exist.

Beginning with MySQL 5.1.27, CHECK TABLE is also supported for
partitioned tables. Also beginning with MySQL 5.1.27, you can use ALTER
TABLE ... CHECK PARTITION to check one or more partitions; for more
information, see [HELP ALTER TABLE], and
http://dev.mysql.com/doc/refman/5.1/en/partitioning-maintenance.html.

URL: http://dev.mysql.com/doc/refman/5.1/en/check-table.html

