Mysql外连查询
left，right，inner JOIN
前言
希望不会再忘记
user表
order表
left join
SELECT
*
FROM
`user` a
LEFT JOIN `order` b ON a.id = b.uid;
right join
SELECT
*
FROM
`user` a
RIGHT JOIN `order` b ON a.id = b.uid;
inner join
SELECT
*
FROM
`user` a
INNER JOIN `order` b ON a.id = b.uid;
后续
痛心成长点滴记录
