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

This article mainly introduces MySQL how to achieve type conversion, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Type conversion

Command: CAST (expr AS type)

Function: mainly used for display type conversion

Application scenarios: display type conversion

Example:

Mysql > select cast (18700000000 as char); +-+ | cast (18700000000 as char) | +-+ | 18700000000 | +-+ 1 row in set (0.00 sec)

It should be noted that not all basic data types are supported by type.

Thank you for reading this article carefully. I hope the article "how to achieve type conversion in MySQL" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.