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

This article mainly introduces how mysql converts numbers into strings, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article.

Mysql will be a number into a string of methods: 1, the use of CHAR () function, syntax "SELECT CONVERT (numeric, CHAR);"; 2, the use of "+" operator, the number and empty string add, syntax "SELECT numeric +';".

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

1. If a number is converted into a string, you can use CHAR and take a look at the sql statement:

SELECT CONVERT (23jinchar)

The running result is shown in the following figure.

2. Convert a number to a string, or you can directly use the "+'" way. The sql statement is as follows:

SELECT 123 thanks'

The running result of the sql is shown in the figure.

Thank you for reading this article carefully. I hope the article "mysql how to convert numbers into strings" shared by the editor will be helpful to everyone. At the same time, I also hope 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.