后面语句所需表如下结构:
员工表:
部门表:
职位等级表:
#02-基本的SELECT语句
USE temp;
SHOW TABLES;
SELECT * #所有的列
FROM employees;
SELECT employee_id,last_name,email
employees:员工表
FROM employees;
SELECT *
FROM departments;
SELECT *
FROM locations;
#列的别名
#as:alias
#可以使用一对""给列起别名
SELECT employee_id id,last_name AS lname,salary AS "monthly salary"
FROM employees;
#去除重复行
SELECT DISTINCT department_id
FROM employees;
#空值参与运算
#结论:空值参与运算的话,结果仍为null
#结论:空值,不同于0,'','null'
SELECT employee_id,last_name,commission_pct,salary *(1 + commission_pct,0) "月工资"
FROM employees;
#IFNULL(commission_pct,0)
#显示表结构
DESC employees;
DESCRIBE employees;