SQL语句的一些知识点

ORDER BY startTime ASC 以startTime进行升序排序

GROUP BY f.startTime

GROUP BY 是与count(*) 一起使用的 表示一startTime为准，其余的都合并。只有StartTime不合并

SELECT f.,u.,p.*
FROM football_hook_up AS f
inner join users AS u on u.usersId=f.footballHookUpUserId //以两个ID作为连接点，把users表和football_hook_up连接成一张表 id相同的——inner join的应用
inner join pitch as p on p.pitchId=f.footballHookUpPitchId
where
usersid in ( //in语句，查询usersId在里面的
select followeeId from user_follow where followerId=3
)
and
pitchId in(
select favorPitchPitchId from favor_pitch where favorPitchUserId=3
)
and startTime> ” and startTime <”;