1.语法
SELECT
column_1, column_2, ...
FROM
table_1
[INNER | LEFT |RIGHT] JOIN table_2 ON conditions
WHERE
conditions
GROUP BY column_1
HAVING group_conditions
ORDER BY column_1
LIMIT offset, length;
语法释义
select
后面跟要查询的内容,中间用逗号分隔;from
指定要查询的表或视图;join
根据某些连接条件从其他表中获取数据;- ‘where’过滤结果集中的行;
group by
将一组行组合成小分组,并对每个小分组应用聚合函数;having
过滤器基于GROUP BY子句定义的小分组;order by
指定用于排序的列的列表;limit
限制返回行的数量;
2.举个例子
SELECT gteam.name
as ‘队伍名称’,members.name
as ‘昵称’,members.truename as ‘真实姓名’,members.mobile as ‘手机号’ FROM gteam LEFT JOIN gteam_members ON gteam.id=gteam_members.teamid LEFT JOIN members ON gteam_members.mid=members.id WHERE gteam_members.isleader=’y’;
,so easy,看下就很容易明白了。