Re: [sqlite] INSERT several rows

2014-04-03 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/04/14 14:37, David King wrote: > ... because of the author's opinions of the standard Python ways to > require packages As said author, the problem is that pip etc authors chose to make it impossible to provide arguments to parts of the install

Re: [sqlite] INSERT several rows

2014-04-03 Thread Roman Fleysher
of Richard Hipp [d...@sqlite.org] Sent: Thursday, April 03, 2014 5:03 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] INSERT several rows On Thu, Apr 3, 2014 at 4:52 PM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > OK, thank you, Igor! I presume there is no w

Re: [sqlite] INSERT several rows

2014-04-03 Thread David King
> Wouldn't it be easier just to upgrade to SQLite 3.8.4.3? Why do you feel > like you need to stick with 3.7.2 which is 3.5 years old (what is that in > internet years? 100?) I can't speak for Roman, but the biggest thing that keeps me from using newer sqlite features is that I write desktop

Re: [sqlite] INSERT several rows

2014-04-03 Thread Richard Hipp
On Thu, Apr 3, 2014 at 4:52 PM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > OK, thank you, Igor! I presume there is no way to get documentation for > older versions -- no point in keeping. > The source code to the historical documentation is online:

Re: [sqlite] INSERT several rows

2014-04-03 Thread Roman Fleysher
, April 03, 2014 4:48 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] INSERT several rows On 4/3/2014 4:23 PM, Roman Fleysher wrote: > Is ability to insert multiple rows in one go a feature of a newer versions: > > INSERT INTO myTable (designation) VALUES ('LoResFA_only'), ('HiR

Re: [sqlite] INSERT several rows

2014-04-03 Thread Richard Hipp
On Thu, Apr 3, 2014 at 4:48 PM, Igor Tandetnik wrote: > On 4/3/2014 4:23 PM, Roman Fleysher wrote: > >> Is ability to insert multiple rows in one go a feature of a newer >> versions: >> >> INSERT INTO myTable (designation) VALUES ('LoResFA_only'), >> ('HiResFA_only'); >> > >

Re: [sqlite] INSERT several rows

2014-04-03 Thread Igor Tandetnik
On 4/3/2014 4:23 PM, Roman Fleysher wrote: Is ability to insert multiple rows in one go a feature of a newer versions: INSERT INTO myTable (designation) VALUES ('LoResFA_only'), ('HiResFA_only'); Support for this syntax was introduced relatively recently. I don't remember which version