mysql中,假如:
tbl_a的字段为id,title,price,details,certificate
tbl_b的字段为id,title,price,details
现在当tbl_a.title等于tbl_b.title时,要将tbl_b的各个字段的内容复制到tbl_a中,
请问,这个sql语句应该如何写?
可以看一下这段是不是符合需求
insert into tbl_a
select * from tbl_b where title in (select title from tbl_a)
certificate如果可以为空的话 字段对应以下插入就行
insert into tbl_a(id,title,price,details)
select id,title,price,details from tbl_b where title in (select title from tbl_a)