查 SELECT * FROM where 限定搜索范圍 = 等于
<> 不等于
大于
< 小于
= 大于等于
<= 小于等于
BETWEEN 在某個(gè)范圍內(nèi)
LIKE 搜索某種模式 % 模糊搜索
SELECT * FROM Persons WHERE City LIKE 'N%' 以N開頭舌狗,后面的字母模糊搜索
SELECT * FROM Persons WHERE City LIKE '%g' 以g結(jié)尾
SELECT * FROM Persons WHERE City LIKE '%lon%' 含有l(wèi)on
and 即條件交集
or 即條件并集
改 Update set where UPDATE 表 SET 列 WHERE
UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson'
UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing' WHERE LastName = 'Wilson'
刪 DELETE from where DELETE FROM 表名稱 WHERE 列名稱 = 值
DELETE FROM Person WHERE LastName = 'Wilson'
增 INSERT INTO INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....)
INSERT INTO Persons VALUES ('Gates', 'Bill', 'Xuanwumen 10', 'Beijing')
INSERT INTO Persons (LastName, Address) VALUES ('Wilson', 'Champs-Elysees‘)
和 sum() SELECT SUM(column_name) FROM table_name
求絕對(duì)值 abs()