sqlite code snippets#

sqlite > SELECT 3 * 5, 10;
15|10

sqlite > SELECT 1 + 2,
...> 6 + 3
3|9

sqlite> SELECT 'abc' AS start, 'xyz' AS end;
abc|xyz
sqlite> .headers on
sqlite> .mode column
sqlite> SELECT 'abc' AS start, 'xyz' AS end;
start   end
------  ----
abc     xyz
sqlite>