Unusual output when trying a SQL Select statement from the command line SQLite version 3.8.8.2 2015-01-30 14:30:45 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open taxi-invoicing-db sqlite> .stats on sqlite> .tables Address Invoice VERSION_CONTROL Customer InvoiceLine sqlite> select * from version_control; Memory Used: 80840 (max 86816) bytes Number of Outstanding Allocations: 182 (max 193) Number of Pcache Overflow Bytes: 6904 (max 6904) bytes Number of Scratch Overflow Bytes: 0 (max 0) bytes Largest Allocation: 64000 bytes Largest Pcache Allocation: 1176 bytes Largest Scratch Allocation: 0 bytes Lookaside Slots Used: 10 (max 54) Successful lookaside attempts: 173 Lookaside failures due to size: 41 Lookaside failures due to OOM: 0 Pager Heap Usage: 7508 bytes Page cache hits: 7 Page cache misses: 6 Page cache writes: 0 Schema Heap Usage: 4032 bytes Statement Heap/Lookaside Usage: 2368 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 8 sqlite> select count(1) from version_control; 0 Memory Used: 81824 (max 86816) bytes Number of Outstanding Allocations: 184 (max 193) Number of Pcache Overflow Bytes: 8080 (max 8080) bytes Number of Scratch Overflow Bytes: 0 (max 0) bytes Largest Allocation: 64000 bytes Largest Pcache Allocation: 1176 bytes Largest Scratch Allocation: 0 bytes Lookaside Slots Used: 6 (max 54) Successful lookaside attempts: 193 Lookaside failures due to size: 46 Lookaside failures due to OOM: 0 Pager Heap Usage: 8672 bytes Page cache hits: 1 Page cache misses: 1 Page cache writes: 0 Schema Heap Usage: 4040 bytes Statement Heap/Lookaside Usage: 1616 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 12 sqlite> .tabls Error: unknown command or invalid arguments: "tabls". Enter ".help" for help sqlite> .tables Address Invoice VERSION_CONTROL Customer InvoiceLine sqlite> .vfsname ?AUX? sqlite> sqlite> .TABLES Error: unknown command or invalid arguments: "TABLES". Enter ".help" for help sqlite> .tables Address Invoice VERSION_CONTROL Customer InvoiceLine sqlite> select * from VERSION_CONTROL; Memory Used: 82024 (max 86816) bytes Number of Outstanding Allocations: 184 (max 196) Number of Pcache Overflow Bytes: 8080 (max 8080) bytes Number of Scratch Overflow Bytes: 0 (max 0) bytes Largest Allocation: 64000 bytes Largest Pcache Allocation: 1176 bytes Largest Scratch Allocation: 0 bytes Lookaside Slots Used: 10 (max 54) Successful lookaside attempts: 448 Lookaside failures due to size: 86 Lookaside failures due to OOM: 0 Pager Heap Usage: 8672 bytes Page cache hits: 12 Page cache misses: 0 Page cache writes: 0 Schema Heap Usage: 4040 bytes Statement Heap/Lookaside Usage: 2368 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 8 sqlite>
See online doc at http://www.sqlite.org/cli.html -- Jonathan Camilleri Mobile (MT): ++356 7982 7113 E-mail: camilleri.jon at gmail.com Please consider your environmental responsibility before printing this e-mail. I usually reply to e-mails within 2 business days. If it's urgent, give me a call.