原文链接:http://www.w3school.com.cn/sql/sql_delete.asp
对象 | 说明 | 举例说明 |
* | 星号(*)是选取所有列的快捷方式 | SELECT * FROM Persons |
distinct | 关键词 DISTINCT 用于返回唯一不同的值。 | sleelct distinct 列名 from 表名 |
where | 1.用于条件筛选 2.支持运算符 > = < != >= <= between like 3、and or | 2 select * from person where name like "张%"
3.例:SELECT * FROM Persons WHERE firstname='Thomas' OR lastname='Carter' |
order by | 对结果进行排序 | 正序:SELECT Company, OrderNumber FROM Orders ORDER BY Company 倒序:SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC( 在第一列中有相同的值时,第二列是以升序排列的。如果第一列中有些值为 nulls 时,情况也是这样的。) |
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')
|
update set | 更新值 | UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值 例:UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing' WHERE LastName = 'Wilson' |
delect | 删除值 | DELETE FROM 表名称 WHERE 列名称 = 值 删除某行 例:DELETE FROM Person WHERE LastName = 'Wilson' 删除所有行 例:DELETE * FROM table_name |