|
|
CHECK TABLE tbl_name[,tbl_name...] [option [option...]]
The option can be one of the following:
CHANGED EXTENDED FAST MEDIUM QUICK
This checks a MyISAM or InnoDB table for errors and, for MyISAM tables, updates the index statistics. The QUICK option doesn't scan the rows to check links. The FAST option only checks tables that weren't closed properly. The CHANGED option is the same as FAST, except that it also checks tables that have changed since the last check. The MEDIUM option verifies that deleted links are correct, and the EXTENDED option does a full index lookup for each key in each row.
|
|