mysql 字符串转数字
方法一:SELECT CAST('123' AS SIGNED);
方法二:SELECT CONVERT('123' AS SIGNED);
方法三:SELECT '123'+0;//亲测有效
mysql 数字转字符串
CONCAT()
转自:http://www.cnblogs.com/-lpf/p/5863892.html
mysql 字符串转数字
方法一:SELECT CAST('123' AS SIGNED);
方法二:SELECT CONVERT('123' AS SIGNED);
方法三:SELECT '123'+0;//亲测有效
mysql 数字转字符串
CONCAT()
转自:http://www.cnblogs.com/-lpf/p/5863892.html