Update ...From(Cross Join in Update):Sqlite 不支持类似的update,替代的解决办法是:
UPDATE table1 SET col2 = (select col2 from table2 where table2.col1=table1.col1 limit 1)
where exists(select * from table2 where table2.col1=table1.col1);
Update ...From(Cross Join in Update):Sqlite 不支持类似的update,替代的解决办法是:
UPDATE table1 SET col2 = (select col2 from table2 where table2.col1=table1.col1 limit 1)
where exists(select * from table2 where table2.col1=table1.col1);
转载于:https://my.oschina.net/u/858166/blog/485560