Re: [sqlite] [OT] Re: i Know i should use 'AS', but ....

2018-12-25 Thread Luuk
On 24-12-2018 21:25, Shawn Wagner wrote: Using '.mode column" in conjunction with ".headers on" you're already using makes it a lot more obvious. like this: SQLite version 3.21.0 2017-10-24 18:55:49 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILEN

Re: [sqlite] [OT] Re: i Know i should use 'AS', but ....

2018-12-24 Thread Shawn Wagner
Using '.mode column" in conjunction with ".headers on" you're already using makes it a lot more obvious. On Mon, Dec 24, 2018, 12:20 PM Luuk On 24-12-2018 19:21, Peter Johnson wrote: > > The headers are present in all three queries you pasted. > > > > The first result shows two rows, the top row

[sqlite] [OT] Re: i Know i should use 'AS', but ....

2018-12-24 Thread Luuk
On 24-12-2018 19:21, Peter Johnson wrote: The headers are present in all three queries you pasted. The first result shows two rows, the top row is the header. The other two results show 4 rows each, the top row of each is the header row. -P On Tue, 25 Dec 2018, 3:42 AM Luuk sqlite> .version