Re: [sqlite] Result set column names

On 7 Dec 2019, at 11:09pm, J. King wrote: > It's stated here, at least: > Also note https://sqlite.org/pragma.html#pragma_short_column_names https://sqlite.org/pragma.html#pragma_full_column_names even though they are now both deprecated.

Re: [sqlite] Result set column names

On December 7, 2019 6:04:36 p.m. EST, Tim Streater wrote: >At various times in various threads on this list it has been stated >that the column name in a result set is not guaranteed unless one uses >AS. IOW, one should say > > select abc as abc from mytable where i=23; > >rather than just: > >

[sqlite] Result set column names

At various times in various threads on this list it has been stated that the column name in a result set is not guaranteed unless one uses AS. IOW, one should say select abc as abc from mytable where i=23; rather than just: select abc from mytable where i=23; I'm trying to find where on

[sqlite] Death of Hector Garcia-Molina

Sad news: death of Hector Garcia-Molina, one of the pioneers in the field of distributed databases. https://news.stanford.edu/2019/12/06/hector-garcia-molina-influential-computer-scientist-database-expert-dies-65/. JLH ___ sqlite-users mailing list

Re: [sqlite] wal mode

On Fri, 6 Dec 2019 at 19:06, Simon Slavin wrote: > On 6 Dec 2019, at 6:39pm, MM wrote: > > > So it suffices that I run "PRAGMA journal_mode=WAL;" once from say the > sqlite3 cli, for all future connections from any tool will use WAL mode for > this database file? > > Correct. > > > What happens

Re: [sqlite] last occurrence of /*

It is possible using ‘with recursive’. The following is ugly and inefficient but might give you some ideas. with recursive cte (x,str) as (select 0,?1 union select x-1,substr(?1,x-1) from cte limit length(?1)) select str from cte where substr(str,1,2)='/*' order by -x limit 1;