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 (as of MySQL 5.0.16) ARCHIVE tables. For MyISAM
tables, the key statistics are updated as well.

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

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

