top of page
MySQL:
CHECKSUM TABLE
Syntax:
CHECKSUM TABLE tbl_name [, tbl_name] ... [QUICK | EXTENDED]
CHECKSUM TABLE reports a checksum for the contents of a table. You can
use this statement to verify that the contents are the same before and
after a backup, rollback, or other operation that is intended to put
the data back to a known state.
This statement requires the SELECT privilege for the table.
This statement is not supported for views. If you run CHECKSUM TABLE
against a view, the Checksum value is always NULL, and a warning is
returned.
For a nonexistent table, CHECKSUM TABLE returns NULL and generates a
warning.
During the checksum operation, the table is locked with a read lock for
InnoDB and MyISAM.
URL: https://dev.mysql.com/doc/refman/8.0/en/checksum-table.html
Example
bottom of page