所有记录 SELECT * FROM users
age=33的记录:SELECT *FROM users WHERE age=33
子键(字段)筛选:SELECT a,b FROM users WHERE age=33
排序 :SELECT * FROM users WHERE! age=33 ORDER BY name
比大小 :SELECT* FROM users WHERE age>33
正则(模糊匹配): SELECT *FROM uses WHERE name LIKE "oe%"
忽略、限制 : SELECT * FROM users LIMIT 10 SKIP20
Or操作 : SELECT * FROM uses WHERE a=10orb=2
仅返回1条(TOP 1) : SELECT * FROM users LIMIT1
Distinct聚合 : SELECT DISTINCT last name FROM uses
Count聚合 : SELECT COUNT(AGE) trom users
查询计划 : EXPLAIN SELECT* FROM users WHEREz=3