复习MySQL篇（1）

一、检索数据

检索单个列
SELECT name FROM teachers;
检索多个列
SELECT name,course FROM teachers;
检索所有列
SELECT * FROM teachers;
检索不同的行
SELECT DISTINCT pro_id FROM products;
限制结果
SELECT name FROM teachers LIMIT 4;
使用完全限定的表名
SELECT products.prod_name FROM product;
二、排序检索数据

排序数据
SELECT name FROM teachers ORDER BY name;
按多个列排序
SELECT name, yr, course FROM teacher order by name, yr;
指定排序方向：默认升序，降序指定关键字DESC
SELECT name ,yr FROM teacher order by yr DESC;
三、过滤数据

使用WHERE子句
SELECT p_name, p_price FROM products WHERE p_price = 5;
WHERE子句操作符：检查单个值
SELECT p_name, p_price FROM products WHERE p_name = ‘apple’;
不匹配检查
SELECT id, p_name FROM products WHERE id <> 001;
范围值检查
SELECT p_name, p_price FROM products WHERE p_price between 5 and 10;
空值检查
SELECT p_name, p_price FROM products WHERE p_price IS NULL;