Concat(a,b)函数
SELECT CONCAT('姓名:',NAME) AS 名单 FROM student;
去重
SELECT DISTINCT sage FROM student
对值运算
SELECT sid AS 学号, sage+1 AS 年龄 FROM student
Concat(a,b)函数
SELECT CONCAT('姓名:',NAME) AS 名单 FROM student;
去重
SELECT DISTINCT sage FROM student
对值运算
SELECT sid AS 学号, sage+1 AS 年龄 FROM student