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

checksum table t1;

时间:2023-02-04 17:35:38浏览次数:47  
标签: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://www.cnblogs.com/igoodful/p/17092004.html

相关文章