spacepaste

Paste details

reply | raw

  1.  
  2. PRAGMA table_info("MyTable")
  3. ()
  4. CREATE TABLE "MyTable" (
  5. priid INTEGER NOT NULL,
  6. secid INTEGER,
  7. PRIMARY KEY (priid)
  8. )
  9. ()
  10. COMMIT
  11. BEGIN (implicit)
  12. INSERT INTO "MyTable" (secid) VALUES (?)
  13. (None,)
  14. INSERT INTO "MyTable" (secid) VALUES (?)
  15. (None,)
  16. INSERT INTO "MyTable" (secid) VALUES (?)
  17. (None,)
  18. INSERT INTO "MyTable" (secid) VALUES (?)
  19. (None,)
  20. INSERT INTO "MyTable" (secid) VALUES (?)
  21. (None,)
  22. INSERT INTO "MyTable" (secid) VALUES (?)
  23. (None,)
  24. INSERT INTO "MyTable" (secid) VALUES (?)
  25. (None,)
  26. INSERT INTO "MyTable" (secid) VALUES (?)
  27. (None,)
  28. INSERT INTO "MyTable" (secid) VALUES (?)
  29. (None,)
  30. INSERT INTO "MyTable" (secid) VALUES (?)
  31. (None,)
  32. UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ?
  33. (1, 1)
  34. UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ?
  35. (2, 2)
  36. UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ?
  37. (3, 3)
  38. UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ?
  39. (4, 4)
  40. UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ?
  41. (5, 5)
  42. UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ?
  43. (6, 6)
  44. UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ?
  45. (7, 7)
  46. UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ?
  47. (8, 8)
  48. UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ?
  49. (9, 9)
  50. UPDATE "MyTable" SET secid=? WHERE "MyTable".priid = ?
  51. (10, 10)
  52. COMMIT
  53. BEGIN (implicit)
  54. SELECT "MyTable".priid AS "MyTable_priid", "MyTable".secid AS "MyTable_secid" FROM "MyTable"
  55. ()
  56.  
Powered by spacepaste. Paste removal.