In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
Today, I would like to share with you the relevant knowledge points about how mysql converts data into binary. The content is detailed and the logic is clear. I believe most people still know too much about this knowledge, so share this article for your reference. I hope you can get something after reading this article. Let's take a look.
Conversion methods: 1, the use of BIN () function, syntax "SELECT BIN (number)"; 2, the use of BINARY () function, syntax "SELECT BINARY" value ""; 3, the use of CAST () function, syntax "SELECT CAST (value AS BINARY)".
The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.
Mysql converts data to binary
Method 1: using the BIN () function
The BIN () function returns the binary representation of a number as a string value.
Syntax:
SELECT BIN (number)
Example: returns a binary representation of 111
SELECT BIN (111)
Method 2: using the BINARY () function
The BINARY function converts a value to a binary string.
Syntax:
SELECT BINARY "data value"
Method 3: using the CAST () function
The CAST () function converts (any type) value to the specified data type.
CAST (value AS BINARY) has the same function as the BINARY () function, which converts a value to a binary string.
BINARY: converting value to BINARY (binary string)
These are all the contents of the article "how mysql converts data to binary". Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more knowledge, please pay attention to the industry information channel.
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.