select语句的使用
基本的selet语句,SELECT 字段1,字段2… FROM 表名
代码用于:http://sqlmother.yupi.icu/#/playground
SELECT 1;
SELECT 1 + 1;
// * 是通配符,全部
SELECT * FROM student;
SELECT name FROM student;
列的别名的三种方式
//(1)
select name as 学生姓名, age as 学生年龄 from student
//(2)
select name 学生姓名, age 学生年龄 from student
//(3)
select name (as)"学生姓名", age "学生年龄" from student
常量和运算
select
name,
score,
score * 2 as double_score
from
student;
去除重复行
SELECT distinct department_id FROM employees;
#错误的
SELECT salary, DISTINCT department_id FROM DELETE;
#仅仅是没有报错,没有实际意义
SELECT DISTINCT salary, department_id FROM employees;
空值参与运算,空值:null,null不等同于0
SELECT employee_id , salary '月工资',salary * (1 + commission_pct)*12 "年工资",commission_pct
FROM employees;
--空值参与运算,为null,没有值,计算不了
着重号
--SELECT * FROM ORDER
SELECT * FROM `order`
//当表名,字段和关键字重名时 加``
查询常数
SELECT 'ikun','两年半', department_id FROM employees;
查询表结构
DESCRIBE employees;
DESC departments;
过滤数据
SELECT *
FROM employees
WHERE last_name = 'king';
#mysql 中 'king' 也可以是 'KING' 或'kiNg'
#不区分大小写
#声明在from 的后面