MySQL实现全连接功能（FULL OUTER JOIN）

MySQL不支持全连接

可通过以下方式实现

with name_1 as (
    select 1    as id,
           '张三' as name,
           20   as `number`
    union all
    select 2    as id,
           '李四' as name,
           30   as `number`
),
     name_2 as (
         select 1    as id,
                '张三' as name,
                10   as `number`
         union all
         select 3    as id,
                '王五' as name,
                30   as `number`
     )
SELECT *
FROM name_1 A
         left outer join name_2 B
                         on a.id = b.id
union
SELECT *
FROM name_1 A
         right outer join name_2 B
                          on a.id = b.id 

结果如下：