本文共 1265 字,大约阅读时间需要 4 分钟。
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://shswn.baihongyu.com/