首页 > 其他分享 >checksum table t1;

checksum table t1;

时间:2023-03-26 11:32:28浏览次数:33  
标签:set checksum t1 +---------+-----------+ sec mysql table

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

 

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)

 

标签:set,checksum,t1,+---------+-----------+,sec,mysql,table
From: https://blog.51cto.com/u_13912516/6150002

相关文章