MySQL-06过滤数据/WHERE子句-必知必会

• 使用搜索/过滤条件来检索所需数据

SELECT * FROM student WHERE id = 1;
SELECT id,age FROM student WHERE id = 1;

• WHERE子句操作符和Java一致，还有 BETWEEN：在指定的两个值之间，<>和！=一个意思

SELECT * FROM student WHERE id <> 1;
SELECT * FROM student WHERE id != 1;
SELECT * FROM student WHERE id BETWEEN 1 AND 2;

• 空值检查

SELECT * FROM student WHERE id IS NULL;