MySQL DQL语句之SELECT

查询表中全部信息

SELECT * FROM players

查询id和name两列

SELECT id,`name` FROM players

别名查询 AS，把结果起个名字

SELECT id as 编号,`name` as 游戏昵称 FROM players

也可以给表起别名

SELECT id as 编号,`name` as 游戏昵称 FROM players as pppp

拼接字符串查询concat()方法，即把结果前面加个东西

SELECT CONCAT('游戏昵称:', `name`) AS 新昵称 FROM players