Structured Query Language | SQL
关系型数据库:Relational database
金老师练习网站:http://www.xuesql.cn/lesson/select_queries_introduction
SQL Lesson 1: SELECT 查询 101
1.语法
SELECT 查询某些属性列(specific columns)的语法
SELECT column(列名), another_column, …
FROM mytable(表名);
2.原表
3.练习
1.请列出所有电影的ID,名称和出版国(即美国)
SELECT title, id, '美国' as country FROM movies`
⚠️ 注意:这里添加了一列(column)变量country作为新的变量,所有行该属性下取值都为“美国”
2.请列出所有电影的信息和出版国(即美国)
SELECT * , '美国' as country FROM movies
--在原表基础上增加一列新的变量
SQL Lesson 2: 条件查询 (constraints) (Pt. 1)
1.语法
SELECT column, another_column, …
FROM mytable
WHERE condition
AND/OR another_condition
AND/OR …;
Operator(关键字) | SQL Example(例子) |
---|---|
=, !=, < <=, >, >= | col_name != 4 |
BETWEEN … AND … | col_name BETWEEN 1.5 AND 10.5 |
NOT BETWEEN … AND … | col_name NOT BETWEEN 1 AND 10 |
IN (…) | col_name IN (2, 4, 6) |
NOT IN (…) | col_name NOT IN (1, 3, 5) |
⚠️ 注意:BETWEEN 1 AND 10 , 为开区间[1,10];
2.原表
3.练习
找到头5部电影
SELECT * FROM movies
limit 5
SELECT * FROM movies
where id <=5
⚠️ 注意:两种表示方法