阅读背景:

在一个SQL查询中使用不同的值更新多个行

来源:互联网 

I have a SQLite database with table myTable and columns id, posX, posY. The number of rows changes constantly (might increase or decrease). If I know the value of id for each row, and the number of rows, can I perform a single SQL query to update all of the posX, posY fields with different values according to the id?I have a SQLite database with table myTable and




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: