CRC32():32-bit unsigned value of the string

SELECT CRC32('string' )
Returns a 32-bit unsigned value of the input string (cyclic redundancy checksum), this can be stored in a table
SELECT CRC32('plus2net'); // Output is 930124482
SELECT CRC32(null);// Output 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

PHP function crc32()

If you are using PHP then you will get same output
echo crc32('plus2net');
Output is 930124482

SQL Math References ABS() to get Absolute value Average value Query
Subscribe to our YouTube Channel here


* indicates required
Subscribe to plus2net

    Post your comments , suggestion , error , requirements etc here

    SQL Video Tutorials

    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 All rights reserved worldwide Privacy Policy Disclaimer