此為自用
查詢語句
1.select
SELECT column1,column2 FROM table1;常用的格式慣例：
大寫了SELECT和FROM，而將表名和列名小寫；
通常在列名中使用下劃線，避免使用空格；
在每個語句末尾添加分號；
SQL不區分大小寫。
2.limit
SELECT name,director FROM movies
LIMIT 15;3.order by
SELECT name, FROM,film_year,ticket_price FROM movies
ORDER BY film_year DESC,ticket_price DESC
LIMIT 5;DESC是倒序
4.where
用在order by之前
SELECT name,film_year FROM movies
WHERE name = '哈利波特'
ORDER BY film_year;5.派生列
假如表movies里沒有列count、country
SELECT film_year,ticket_price,film_year/ticket_price AS count'England'AS country
FROM movies
WHERE name = '哈利波特'
ORDER BY film_year
LIMIT 5;邏輯運算符
1.like.
SELECT name FROM movies
WHERE name LIKE '%哈利%';2.in.
SELECT name,director FROM movies
WHERE name IN ('哈利波特','魔戒');3.not.
SELECT name FROM movies
WHERE name NOT LIKE '哈利%';SELECT name,director FROM movies
WHERE name NOT IN ('哈利波特','魔戒');4.and 與 between
SELECT name, director FROM movies
WHERE film_year = 2000 and name = '哈利波特';SELECT name,director FROM movies
WHERE film_day NOT BETWEEN 2000-01-01 AND 2010-01-01;between包含端點值，但對于時間2010-01-01是2010-01-01 0:00:00
5.or.
SELECT name,director FROM movies
WHERE (film_year = 2000 OR film_year = 2010) AND name = '哈利波特'
ORDER BY film_year;
