CRC32() function

SELECT CRC32('string' )

Returns a 32-bit unsigned value of the input string, this can be stored in a table

SELECT CRC32('plus2net'); // Ouput is 930124482
SELECT CRC32(null);// Ouput is NULL

The input is treated as string .

Column Structure to Insert

If you are storing the output of crc32() then the column should be INT and attributes should be UNSIGNED

If you are using PHP then you will get same output

<?Php
echo crc32('plus2net');
?>

Output is 930124482

Your Rating

▼ More on Math functions in SQL