On Thu, Feb 23, 2012 at 8:25 AM, Petite Abeille <petite.abei...@gmail.com>wrote:
> > On Feb 23, 2012, at 2:16 PM, Abhinav Upadhyay wrote: > > > . I was wondering if I could insert them using a > > single INSERT query > > Ah, also, there is not much benefit in using a compound insert. > > You could as well simply insert all your values in one transaction and be > done. > > On the other hand, the forthcoming 3.7.11 release seems to support > multi-valued insert statements. > > http://www.sqlite.org/draft/releaselog/3_7_11.html > The new multi-valued insert is merely syntactic suger for the compound insert. There is no performance advantage one way or the other. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users