Returns a 32-bit unsigned value of the input string, this can be stored in a table
SELECT CRC32('string' )
The input is treated as string .
SELECT CRC32('plus2net'); // Ouput is 930124482
SELECT CRC32(null);// Ouput is NULL
Column Structure to Insert
If you are storing the output of crc32() then the column should be INT and attributes should be UNSIGNED
PHP function crc32()
If you are using PHP then you will get same output
Output is 930124482
This article is written by plus2net.com team.
| ▼ More on Math functions in SQL|