Syntax
CHECKSUM TABLE tbl_name [, tbl_name] ... [ QUICK | EXTENDED ]
Description
CHECKSUM TABLE reports a table checksum. This is very
useful if you want to know if two tables are the same (for example on a master
and slave).
With QUICK, 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 when you create the table; currently, this is supported
only for Aria and MyISAM tables.
With EXTENDED, the entire table is read row by row and the
checksum is calculated. This can be very slow for large tables.
If neither QUICK nor EXTENDED is
specified, MariaDB returns a live checksum if the table storage engine supports
it and scans the table otherwise.
For a nonexistent table, CHECKSUM TABLE returns
NULL and generates a warning.
Differences between MariaDB and MySQL
CHECKSUM TABLE may give different result as MariaDB doesn't
ignore NULL's in the columns as MySQL 5.1 does (Future MySQL
versions should calculate checksums the same way as MariaDB). You can get the
'old style' checksum in MariaDB by starting mysqld with the
--old option. Note however that that the MyISAM and Aria
storage engines in MariaDB are using the new checksum internally, so if you are
using --old, the CHECKSUM
command will be
slower as it needs to calculate the checksum row by row.
