PRAGMA table_info("MyTable") () CREATE TABLE "MyTable" ( priid INTEGER NOT NULL, secid INTEGER, PRIMARY KEY (priid) ) () COMMIT BEGIN (implicit) INSERT INTO "MyTable" (secid) VALUES (?) (None,) INSERT INTO "MyTable" (secid) VALUES (?) (None,) INSERT INTO "MyTable" (secid) VALUES (?) (None,) INSERT INTO "MyTable" (secid) VALUES (?) (None,) INSERT INTO "MyTable" (secid) VALUES (?) (None,) INSERT INTO "MyTable" (secid) VALUES (?) (None,) INSERT INTO "MyTable" (secid) VALUES (?) (None,) INSERT INTO "MyTable" (secid) VALUES (?) (None,) INSERT INTO "MyTable" (secid) VALUES (?) (None,) INSERT INTO "MyTable" (secid) VALUES (?) (None,) UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ? (1, 1) UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ? (2, 2) UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ? (3, 3) UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ? (4, 4) UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ? (5, 5) UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ? (6, 6) UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ? (7, 7) UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ? (8, 8) UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ? (9, 9) UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ? (10, 10) COMMIT BEGIN (implicit) SELECT "MyTable".priid AS "MyTable_priid", "MyTable".secid AS "MyTable_secid" FROM "MyTable" ()