tbl_name] ... [ QUICK | EXTENDED ]
CHECKSUM TABLE reports a table
QUICK, the live table checksum is
reported if it is available, or
otherwise. This is very fast. A live checksum is enabled by
CHECKSUM=1 table option when
you create the table; currently, this is supported only for
MyISAM tables. See
Section 12.1.5, “
CREATE TABLE Syntax”.
EXTENDED, the entire table is read row
by row and the checksum is calculated. This can be very slow for
EXTENDED is specified, MySQL returns a live
checksum if the table storage engine supports it and scans the
For a nonexistent table,
The checksum value depends on the table row format. If the row
format changes, the checksum also changes. For example, the
storage format for
changed between MySQL 4.1 and 5.0, so if a 4.1 table is upgraded
to MySQL 5.0, the checksum value may change.
This statement is implemented in MySQL 4.1.1.
If the checksums for two tables are different, then it is
almost certain that the tables are different in some way.
However, because the hashing function used by
CHECKSUM TABLE is not
guaranteed to be collision-free, there is a slight chance that
two tables which are not identical can produce the same