您可以为此使用CRC32校验和。语法如下-SELECT SUM(CRC32(yourColumnName)) AS anyAliasName FROM yourTableName;
为了理解上述语法,让我们创建一个表。创建表的查询如下-mysql> create table CRC32Demo
-> (
-> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> UserId varchar(20)
-> );
使用insert命令在表中插入一些记录。查询如下-mysql> insert into CRC32Demo(UserId) values('USER-1');
mysql> insert into CRC32Demo(UserId) values('USER-123');
mysql> insert into CRC32Demo(UserId) values('USER-333');
使用select语句显示表中的所有记录。查询如下-mysql> select *from CRC32Demo;
输出结果+----+----------+
| Id | UserId |
+----+----------+
| 1 | USER-1 |
| 2 | USER-123 |
| 3 | USER-333 |
+----+----------+
3 rows in set (0.00 sec)
这是创建列的总校验和的查询-mysql> select sum(crc32( UserId)) from CRC32Demo;
输出结果+---------------------+
| sum(crc32( UserId)) |
+---------------------+
| 3142885447 |
+---------------------+
1 row in set (0.00 sec)