SQL语句

1、CREATE TABLE

CREATE TABLE "表格名"

("欄位 1""欄位 1資料種類",
"欄位 2" "欄位 2資料種類",
... );

CREATE TABLE Customer
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date datetime);

添加主键：

CREATE TABLE Customer 
(SID integer, 
Last_Name varchar(30), 
First_Name varchar(30), 
PRIMARY KEY (SID));

 2、ALTER

ALTER TABLE "table_name "[改變方式];

ALTER TABLE Customer ADD Gender char(1);

ALTER TABLE Customer CHANGE Address Addr char(50);

ALTER TABLE Customer MODIFY Addr char(30);

ALTER TABLE Customer DROP Gender;

 3、DROP TABLE

DROP TABLE "表格名";

DROP TABLE Customer;

 4、Select

SELECT "列名" FROM"表格名";

SELECT DISTINCT "列名" FROM"表格名";

SELECT "列名" FROM "表格名" WHERE"條件";

SELECT "列名" FROM "表格名" WHERE"簡單條件" {[AND|OR]"簡單條件"}+;

SELECT "列名" FROM"表格名" WHERE"列名" IN ('值一', '值二', ...);

SELECT "列名" FROM "表格名" WHERE"列名" BETWEEN '值一' AND '值二';

ORDER BY "列名一" [ASC,DESC], "列名二" [ASC, DESC]

 5、INSERT

INSERT INTO "表格名" ("欄位1","欄位2", ...)
VALUES ("值1", "值2", ...);

INSERT INTO Store_Information (Store_Name, Sales, Txn_Date)
VALUES ('Los Angeles', 900, 'Jan-10-1999');

 6、UPDATE

UPDATE "表格名" SET"列1" = [新值] WHERE "條件";

UPDATE Store_Information
SET Sales = 500
WHERE Store_Name = 'Los Angeles' 
AND Txn_Date = 'Jan-08-1999';

 7、DELETE

DELETE FROM "表格名"
WHERE "條件";

学习：http://www.1keydata.com/tw/sql/sqlselect.html