1. 数字转字符串
-- 1. CONCAT 拼接,CONCAT 函数可以拼接多个值
SELECT CONCAT(123,'aa',456) AS str;
-- 2. CAST 类型转换,转字符串一定要用 CHAR,不能用 VARCHAR
SELECT CAST(123 AS CHAR) AS str;
2. 字符串转数字
-- 1. CAST 类型转换
SELECT CAST('123' AS SIGNED);
-- 2. CONVERT 类型转换
SELECT CONVERT('123', SIGNED);