insert into B
(
select A.* from A
left join B
using (id,name,address)
where B.id is null and B.name is null and B.address is null
)没有试过,看看行不行
(
select A.* from A
left join B
using (id,name,address)
where B.id is null and B.name is null and B.address is null
)没有试过,看看行不行
是什么意思??
using(id) == on A.id=B.id
所以我想
using(id,name,address) == on A.id=B.id AND A.name=B.name AND A.address=B.address详细看看MySQL手册中的用法吧。
to:shinesuny(方舟) 支持。
那这个问题不用子查询来写的话,就不能解决了么?:(有谁知道的呀?