Tutorial Gateway

MySQL CRC32 Function

by

MySQL CRC32 function is one of the Mathematical Function which computes the cyclic redundancy value. The return value of this function is 32 bit unsigned integer.

In this article, we will show you, How to find cyclic redundancy value in MySQL using Command Prompt, and Workbench with examples.

MySQL CRC32 Syntax

The syntax of the CRC32 in MySQL is as shown below:

SELECT CRC32(expression);

This function accepts string expression as an output. If not, it will convert the given value into a string.

MySQL CRC32 Function Example 1

The MySQL CRC32 is used to return the Cylindric Redundancy of given value. The following query will show multiple ways to use CRC32 function.

SELECT CRC32('MySQL');

SELECT CRC32('tutorial gateway');

SELECT CRC32('Hello'), CRC32('Hi'), CRC32('World');

OUTPUT

MySQL CRC32 Function 1

MySQL CRC32 Example 2

In this example, we are going to find the Cylindric Redundancy value of Last Name and Occupation columns.

SELECT EmpID, 
       FirstName,
       LastName,
       CRC32(LastName),
       Occupation,
       CRC32(Occupation),
       YearlyIncome,
       Sales
 FROM `MySQL Tutorial`.customer;

OUTPUT

MySQL CRC32 Function 2

Thank You for Visiting Our Blog