mysql A,B张表对比查询

根据number 对比 AB A有B没有 所有结果

 select * from A as a
 left join   B as b on a.number=b.number  where b.number is null

根据number 对比 AB 中ggxh ，name不一致的所有数据

select a.id,a.number ,a.ggxh,a.`name`,b.number ,b.ggxh,b.`name`
from A as a INNER JOIN
 B as b on a.number=b.number WHERE a.ggxh <> b.ggxh OR a.`name` <>  b.`name`