2021-08-03 SELECT简单查询

-- 查询全部的学生
SELECT * FROM student

SELECT * FROM result
-- 查询指定字段
SELECT `studentno`, `studentname` FROM student

-- 使用别名 AS
SELECT `studentno` AS 学号, `studentname` AS 学生姓名 FROM student AS 学生表

-- 函数 Concat(a,b) 拼接字段
SELECT CONCAT('姓名: ',studentname) AS 新名字 FROM student AS S