我後悔了,前幾篇不應該寫什麼密碼學,萬惡的數學,還是回來web的懷抱吧ಥ_ಥ
dessert_name | price |
---|---|
cake | 50 |
macaron | 100 |
Donuts | 200 |
表格名稱:dessert_table
FROM、SELECT
SELECT "欄位名稱" FROM "表格名稱";
SELECRT dessert_name FROM dessert_table;
WHERE
SELECT "欄位名稱" FROM "表格名稱" WHERE "條件";
SELECT dessert_name FROM dessert_table WHERE price < 100
ADN、OR
SELECT "欄位名稱" FROM "表格名稱" WHERE "條件" OR/AND "條件" ;
SELECT dessert_name FROM dessert_table WHERE price<100 AND price>150 ;
ORDER BY
SELECT "欄位名稱" FROM "表格名稱" [WHERE "條件" ] ORDER BY "欄位名稱" [ASC/DESC] ;
SELECT dessert_name,price FROM dessert_table ORDER BY price ASC ;
LIMIT
ELECT "欄位名稱" FROM "表格名稱" LIMIT "數量" ;
ELECT dessert_name FROM dessert_table LIMIT 2 ;
CREATE
CREATE DATABASE "資料庫名稱";
CREATE TABLE "表格名稱"
("欄位 1" "欄位 1 資料種類",
"欄位 2" "欄位 2 資料種類",
... );