MySQL学习笔记——04.DQL语言学习.基础查询
-
查询表中单个字段
SELECT ‘first_name’ FROM ‘employees’;
-
查询表中多个字段
SELECT ‘first_name’,‘last_name’,‘email’ FROM ‘employees’;
-
查询常量
SELECT 100;
-
查询表达式
SELECT 9*10;
-
查询函数
SELECT version();
-
起别名
SELECT ‘first_name’ AS 名 FROM ‘employees’;
-
去重
SELECT DISTINCT ‘job_id’ FROM ‘employees’;
-
“+”作用
SELECT ‘first_name’+‘last_name’ AS 姓名 FROM ‘employees’;
-
concat连接
SELECT CONCAT(‘first_name’,‘last_name’) AS 姓名 FROM ‘employees’;