Question

如果将两个查询结果分别写入两个表中，又可以如何操作？换成PHP代码又如何写？谢谢~~

Answer 1

create table C as select A.name,A.plz from A left join B on a.plz=B.plz where B.plz is not null;
create table D as select A.name,A.plz from A left join B on a.plz=B.plz where B.plz is null;
insert into C select A.name,A.plz from A left join B on a.plz=B.plz where B.plz is not null;
insert into D select A.name,A.plz from A left join B on a.plz=B.plz where B.plz is null;

Answer 2

事物