Skip to main content

CRC32

Returns the CRC32 checksum of a string.

Syntax​

CRC32(x)

Arguments​

ArgumentsDescription
xThe argument is expected to be a string and (if possible) is treated as one if it is not.

Return Type​

UInt32.

Examples​

mysql> SELECT CRC32('MySQL');
+----------------+
| CRC32('MySQL') |
+----------------+
| 3259397556 |
+----------------+
1 row in set (0.09 sec)

mysql> SELECT CRC32('mysql');
+----------------+
| CRC32('mysql') |
+----------------+
| 2501908538 |
+----------------+
1 row in set (0.01 sec)

mysql> SELECT CRC32(NULL);
+-------------+
| CRC32(NULL) |
+-------------+
| NULL |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT CRC32(12);
+------------+
| CRC32(12) |
+------------+
| 1330857165 |
+------------+
1 row in set (0.01 sec)