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

This article mainly introduces how mysql converts strings into numbers, which is very detailed and has certain reference value. Friends who are interested must finish reading it!

Mysql will string into numeric methods: 1, the use of "+" operator, syntax "string" + 0 "; 2, the use of cast () function, syntax" cast ('string' as numeric type) "; 3, the use of convert () function, syntax" convert ('string', numeric type) ".

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

Three ways of converting mysql string to number

Method 1: + 0

Method 2: cast ('string' as numeric type)

Numeric types can be divided into three types:

Integer: SIGNED

Unsigned integers: UNSIGNED

Floating point numbers: DECIMAL

Method 3: convert ('string', numeric type)

Numeric types can also be divided into three types:

Integer: SIGNED

Unsigned integers: UNSIGNED

Floating point numbers: DECIMAL

These are all the contents of the article "how mysql converts strings into numbers". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow 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.