Collections:
CRC32() - Cyclic Redundancy Check 32-Bit
How to calculate the 32-bit CRC (Cyclic Redundancy Check) value using the CRC32() function?
✍: FYIcenter.com
CRC32(str) is a MySQL built-in function that calculates the 32-bit CRC (Cyclic Redundancy Check) value of a given character string and returns it as an integer. For example:
SELECT CRC32('MySQL'), HEX(CRC32('MySQL')); -- +----------------+---------------------+ -- | CRC32('MySQL') | HEX(CRC32('MySQL')) | -- +----------------+---------------------+ -- | 3259397556 | C24675B4 | -- +----------------+---------------------+ SELECT CRC32('123456789'), HEX(CRC32('123456789')); -- +--------------------+-------------------------+ -- | CRC32('123456789') | HEX(CRC32('123456789')) | -- +--------------------+-------------------------+ -- | 3421780262 | CBF43926 | -- +--------------------+-------------------------+
Reference information of the CRC32() function:
CRC32(str): crc Calculates the 32-bit CRC (Cyclic Redundancy Check) value of a given character string and returns it as an integer. Arguments, return value and availability: str: Required. The character string to be processed. crc: Return value. The 32-bit CRC value as an integer. Available since MySQL 4.0.
⇒ MD5() - Calculating MD5 Hash
⇐ COMPRESS() - Compressing Data
2023-12-19, 249🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...