- sqlite> .schema mytest
- CREATE TABLE "mytest" ("Id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "TestName" varchar(40), "FTestVar" bit, "created_at" datetime, "updated_at" datetime);
- sqlite> select * from mytest;
- 1|A|0||
- 2|B|1||
- 3|C|0||
- 4|D|1||
- 5|E|0||
- 6|F|0||
- 7|G|1||
- sqlite>