将B表数据更新到A表中不同数据库的实现方式。

最新推荐文章于 2022-04-29 10:47:56 发布

weixin_34370347

最新推荐文章于 2022-04-29 10:47:56 发布

阅读量202

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/guiguketang/blog/729724

版权

2019独角兽企业重金招聘Python工程师标准>>>

1>、mysql UPDATE student_address sa INNER JOIN student s ON s.id=sa.stuid SET sa.class=s.class

2>、sqlite（前提，表student、student_address必须有主键） INSERT OR REPLACE INTO student_address (id,stuid, class,address) SELECT student_address.id,student_address.stuid,student.class ,student_address.address FROM student_address, student WHERE student.id = student_address.stuid;

3>、oracle UPDATE student_address sa SET sa.class=(select s.class from student s where s.id=sa.stuid) where sa.stuid in(select id from student);

--更新多列： UPDATE student_address sa SET (sa.class,sa.name)=(select s.class, s.name from student s where s.id=sa.stuid) where sa.stuid in(select id from student);

4>、sqlserver update student_address set class=s.class,name=s.name from student s where student_address.stuid=s.id

转载于:https://my.oschina.net/guiguketang/blog/729724