比如 select a.id from person as a inner join person_info as b on a.guid=b.guid我现在想查 没有关联的部分... 因为没建约束 那部分应该是没删干净 所以想查出来 删掉
select a.id from person as a inner join person_info as b on a.guid<>b.guid 这样写 貌似 都查出来了....请教大虾们 该扎写?
select a.id from person as a inner join person_info as b on a.guid<>b.guid 这样写 貌似 都查出来了....请教大虾们 该扎写?
where a.id is null or b.id is null
select
*
from
person as a full join person_info as b on a.guid=b.guid
where
a.id is null or b.id is null
where a.id is null or b.id is null删除的话 要分别从两个表中删除delete a from person as a full join person_info as b on a.guid=b.guid
where a.id is null delete b from person as a full join person_info as b on a.guid=b.guid
where b.id is null
delete a from person as a left join person_info as b on a.guid=b.guid
where a.id is null delete b from person_info as b left join person as a on a.guid=b.guid
where b.id is null