checksum table t1;

###################

 

mysql> checksum table t1;
+---------+-----------+
| Table   | Checksum  |
+---------+-----------+
| test.t1 | 372885777 |
+---------+-----------+
1 row in set (0.00 sec)

mysql>  select * from t1;
+------+
| a1   |
+------+
|    3 |
|    3 |
|    4 |
|    6 |
+------+
4 rows in set (0.00 sec)

mysql> delete from t1 where a1=3;
Query OK, 2 rows affected (0.01 sec)

mysql> checksum table t1;
+---------+------------+
| Table   | Checksum   |
+---------+------------+
| test.t1 | 1305620691 |
+---------+------------+
1 row in set (0.00 sec)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

###############