SQLite Forum

Question on internals: Sync between WAL and B Tree
Login
Thank you! That explains some questions. But then how would the following work?

```
UPDATE myTable SET ID = ID + 1;
```

1. First fetch the existing the value of ID (say its 23)

2. Write to WAL that ID = 24


something like this?