How to convert string to number in mysql

Mysql method to convert a string into a number: 1. Use the " " operator, the syntax "'string' 0"; 2. Use the cast() function, the syntax "cast('string' as Numerical type)"; 3. Use the convert() function, the syntax is "convert('string', numerical type)".

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

mysql Three ways to convert string to number

Method 1: 0

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

Numeric types can be divided into three types:

Integers: SIGNED

Unsigned integer: UNSIGNED

Floating point number: DECIMAL

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

Numeric types can also be divided into three types:

Integer: SIGNED

Unsigned integer: UNSIGNED

mysql video tutorial】

The above is the detailed content of How to convert string to number in mysql. For more information, please follow other related articles on the PHP Chinese website!