Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 10th, 2012  |  syntax: None  |  size: 0.28 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. sqlite> .schema mytest
  2. CREATE TABLE "mytest" ("Id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "TestName" varchar(40), "FTestVar" bit, "created_at" datetime, "updated_at" datetime);
  3. sqlite> select * from mytest;
  4. 1|A|0||
  5. 2|B|1||
  6. 3|C|0||
  7. 4|D|1||
  8. 5|E|0||
  9. 6|F|0||
  10. 7|G|1||
  11. sqlite>