SQLite Forum

Is the order conserved in a table from a VALUES clause?
Login
Yes.  Always. It must be.  There can be no change nor discussion on this point.

The parent of your so-called VALUES clause originates from the usage in an INSERT statement.  It has just been generalized to not require an `INSERT INTO` prefix.

`INSERT INTO x VALUES (1), (2), (3) ...;`

is absolutely nothing more than semantic sugar for:

```
INSERT INTO x VALUES (1);
INSERT INTO x VALUES (2);
INSERT INTO x VALUES (3);
...
```

Therefore the processing of the list of values sets *must* be left-to-right (in order specified).

QED