Mysql numeric type Conversion Function

Mysql numeric type conversion function 1. concat is often used to convert Int to varchar, such as concat (8, '0 ') obtain the string '80' 2. Convert varchar to Int and use cast (a as signed) a as a string of the varchar type www.2cto.com. Conclusion: The type conversion is the same as that of SQL Server, that is, the type parameters are a bit different: CAST (xxx AS type), CONVERT (xxx, type) Available Type binary, the same effect with the BINARY Prefix: binary encoding type, with parameters: CHAR () DATE: date time: time date type: DATETIME floating point number: decimal integer: signed unsigned integer: UNSIGNED