sqlite数据库的update多表关联更新语句,和其他数据库有点小不一样
update table1
set num1 = t2.num2
FROM table1 t1 INNER JOIN table2 t2
ON t1.id=t2.pid;
update table1
set num1 = (select num2 from table2 where table2.pid=table1.id)
where...
update table1
set num = 99
where table1.id=(select pid from table2 where table2.pid=table1.id)
联系客服