CRC32 mysql function to return 32 bit unsigned value for a sting input using MySQL query

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

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

Output is 930124482

SQL Math References ABS() to get Absolute value Average value Query

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

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

Column Structure to Insert

PHP function crc32()

Subhendu Mohapatra