sql 基础语法

SQL语句执行顺序如下：
FROM - ON - JOIN - WHERE - GROUP BY - WITH - HAVING - SELECT - DISTINCT - ORDER BY - LIMIT

distinct  去重

# 注意  DISTINCT 要放到列名的前面。


SELECT DISTINCT university from user_profile

limit  限制查询数量

select * from tableName limit i,n
# tableName：表名
# i：为查询结果的索引值(默认从0开始)，当i=0时可省略i
# n：为查询结果返回的数量
# i与n之间使用英文逗号","隔开

in  查找多个值

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)

regexp  正则表达式

SELECT * 
FROM users
WHERE email NOT REGEXP '^[A-Z0-9._%-]+@[A-Z0-9.-]+.[A-Z]{2,4}$'

#  ^a  以a开头
#  %   任意字符

desc  逆序

order by gpa desc

group by  分组

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
#常用于合计函数
#aggregate_function
#sum()    avg()

having 聚合函数的筛选条件

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value


#group by 后面可以使用聚合函数