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>