Shulou(Shulou.com)05/31 Report--

Editor to share with you how to convert mysql to binary. I hope you will get something after reading this article. Let's discuss it together.

Mysql base conversion method: 1, the use of "bin (value)", you can convert the decimal to binary; 2, the use of "oct (value)", you can convert the decimal to octal; 3, the use of "hex (value)", you can convert the decimal to hexadecimal; 4, the use of "conv ('value', 2J10)", you can convert the binary to decimal.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

Conversion between mysql bases

1. Convert decimal to binary

Select bin (5)

2. Convert decimal to octal

Select oct (5)

3. Convert decimal to hexadecimal

Select hex (5)

4. Convert binary to decimal

Select conv ('101 million page2, 10)

5. Convert decimal to hexadecimal

Select conv ('20 years, 10, 16)

After reading this article, I believe you have a certain understanding of "how to convert mysql to binary". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.