对数据
增 insert into
删 delete
改 update
查 select
普通查询
select 列名,/* from 表名
查询条件
去重 DISTINCT语句
SELECT DISTINCT 列名称 FROM 表名称
eg.
select dictinct userName from user;
排序 ORDER BY(字母,数字)语句
正序(升序)
默认正序 ASC
按字母顺序显示公司名称:
SELECT Company, OrderNumber FROM Orders ORDER BY Company
按先公司名称按字母显示,再按数字顺序显示顺序号:
SELECT Company, OrderNumber FROM Orders ORDER BY Company, OrderNumber
倒序(降序)
DESC
按逆序排列
SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC
组合
以逆字母顺序显示公司名称,并以数字顺序显示顺序号
SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC
操作条件
WHERE 子句
操作(增删改查)+ where + 条件
eg:SELECT * FROM Persons WHERE City=‘Beijing’
AND&OR(多个条件)
AND且
SELECT * FROM Persons WHERE FirstName=‘Thomas’ AND LastName=‘Carter’
OR或
SELECT * FROM Persons WHERE firstname=‘Thomas’ OR lastname=‘Ca