建库跑路笔记——基础查询（一）

基础查询

#基础查询
/*
	select 查询列表 from 表名;
*/
USE myemployees;
SELECT last_name FROM employees;
SELECT lats_name,salary,email FROM employees;

#所有字段
SELECT * FROM employees;

#查询常量值
SELECT 100;
SELECT 'john';

#查询函数
SELECT VERSION();

#查询表达式
SELECT 100%98;

#起别名
SELECT 100%98 AS 结果;
SELECT last_name AS 姓,first_name AS 名 FROM employees;
SELECT last_name 姓,first_name 名 FROM employees;

#去重
SELECT DISTINCT department_id FROM employees;

#+号的作用————查询员工姓名
SELECT NULL+9;  	#一方为null，结果为null
SELECT 9+10;		#结果为19
SELECT '9'+10;		#结果为19
SELECT 'king'+10; 	#结果为10,字符转化数值失败默认为0
SELECT CONCAT('a','b','c') AS 结果; 
SELECT 
	CONCAT(last_name,first_name) AS 姓名
FROM
	employees;

#显示表的结构
DESC departments;

#显示`employees`部分列，用逗号连接，列头显示out_put
SELECT
	IFNULL(`commission_pct`,0) AS 奖金率,
	`commission_pct` 	#奖金率为null时显示0
FROM employees;
SELECT 
	CONCAT(`first_name`,',',`last_name`,',',`job_id`,',',IFNULL(`commission_pct`,0)) AS out_put
FROM `employees`; 	#部分奖金率为null无法连接，需要显示成0