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. 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.

To check a table, you must have some privilege for it.

CHECK TABLE works for InnoDB, MyISAM, ARCHIVE, and CSV tables.

Before running CHECK TABLE on InnoDB tables, see
https://dev.mysql.com/doc/refman/5.7/en/check-table.html#check-table-in
nodb.

CHECK TABLE is supported for partitioned tables, and you can use ALTER
TABLE ... CHECK PARTITION to check one or more partitions; for more
information, see [HELP ALTER TABLE], and
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html.

CHECK TABLE ignores virtual generated columns that are not indexed.

URL: https://dev.mysql.com/doc/refman/5.7/en/check-table.html

