(mysql.info.gz) CHECKSUM TABLE
Info Catalog
(mysql.info.gz) CHECK TABLE
(mysql.info.gz) Table maintenance SQL
(mysql.info.gz) OPTIMIZE TABLE
13.5.2.4 `CHECKSUM TABLE' Syntax
................................
CHECKSUM TABLE TBL_NAME [, TBL_NAME] ... [ QUICK | EXTENDED ]
Reports a table checksum.
If `QUICK' is specified, the live table checksum is reported if it is
available, or `NULL' otherwise. This is very fast. A live checksum is
enabled by specifying the `CHECKSUM=1' table option, currently
supported only for `MyISAM' tables. `CREATE TABLE' CREATE TABLE.
In `EXTENDED' mode the whole table is read row by row and the checksum
is calculated. This can be very slow for large tables.
By default, if neither `QUICK' nor `EXTENDED' is specified, MySQL
returns a live checksum if the table storage engine supports it and
scans the table otherwise.
This statement is implemented in MySQL 4.1.1.
Info Catalog
(mysql.info.gz) CHECK TABLE
(mysql.info.gz) Table maintenance SQL
(mysql.info.gz) OPTIMIZE TABLE
automatically generated byinfo2html