DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(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