My table was like this:
CREATE TABLE t(x INTEGER PRIMARY KEY, y);
then I did insert: INSERT INTO t VALUES (115,200); INSERT INTO t VALUES (16,300); INSERT INTO t VALUES (250,300);
The problem is: My query "SELECT * FROM t" always sorted ascending automatically by x (primary key). I'm using tksqlite gui to test. The result:
How to get records without sorted automatically (based on order of insert) and without additional column e.g: timestamp?