What is the method of using the BIN () function in MySQL

Editor to share with you what the method of using the BIN () function in MySQL is, I believe most people do not know much about it, so share this article for your reference, I hope you will get a lot after reading this article, let's go to know it!

The BIN () function in MySQL converts a decimal number to a binary number. The BIN () function is equivalent to the CONV () function in the format CONV (number,10,2). The number function converts a number with a base of 10 (decimal) to a number with a base of 2 (binary).

The BIN () function syntax:

BIN (NUM)

Parameters:

NUM: this is the decimal number for which you want to find its binary equivalent.

Return value:

The BIN () function returns a string value, the binary equivalent of the decimal number passed as an argument. Returns NULL if the number is NULL.

Example 1:

Convert 5 to its binary equivalent.

Syntax:

Output:

'101'

Example 2:

Convert 12 to a binary equivalent.

Syntax:

Output:

'1100'

Example 3:

Convert 97 to a binary equivalent.

Syntax:

Output:

'1100001'is all about what the method of using the BIN () function in MySQL is. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!