:: DEVELOPER ZONE
MySQL Reference Manual :: 13.5.2.4 CHECKSUM TABLE Syntax
Search the MySQL manual:
- 13.5.2 Table Maintenance Statements
- 13.5.2.1 ANALYZE TABLE Syntax
- 13.5.2.2 BACKUP TABLE Syntax
- 13.5.2.3 CHECK TABLE Syntax
- 13.5.2.4 CHECKSUM TABLE Syntax
- 13.5.2.5 OPTIMIZE TABLE Syntax
- 13.5.2.6 REPAIR TABLE Syntax
- 13.5.2.7 RESTORE TABLE Syntax
Additional languages
Additional formats
CHECKSUM TABLEtbl_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. See
Section 13.1.5, “CREATE TABLE Syntax”.
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.
CHECKSUM TABLE returns NULL
for non-existent tables. As of MySQL 5.0.3, a warning is generated
for this condition.
This statement is implemented in MySQL 4.1.1.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.