April 2008
Intermediate to advanced
566 pages
21h 55m
English
CRC32()
CRC32(string)This function returns the given string’s cyclic redundancy check (CRC) value as a 32-bit unsigned value. It’s available as of version 4.1 of MySQL. It returns NULL if given a NULL value. Even if a numeric value is given, it treats the value as a string:
SELECT CRC32('test');
+---------------+
| CRC32('test') |
+---------------+
| 3632233996 |
+---------------+Read now
Unlock full access