CHECK TABLE syntax
CHECK TABLE tbl_name[,tbl_name...] [TYPE = QUICK]
Check the table(s) for errors. The command returns a table with the following columns:
| Table | Table name |
| Op | Always 'check' |
| Msg_type | One of status, error, info or warning. |
| Msg_text | The message. |
Note that you can get many rows of information for each checked table. The last one row will be of Msg_type status and should normally be OK. If you don't get OK, you should normally run a repair of the table. See section 15.1 Using myisamchk for table maintenance and crash recovery.
If TYPE=QUICK is given then MySQL will not scan the rows for table with fixed size records.
CHECK TABLE only works on MyISAM tables and is the same things as running myisamchk -m table_name on the table.