Sorry, that was just mistake in reducing the code for the email, please ignore.
What do you mean "what matters is order of columns in table"? or was that just referring to the typo? Jeff Archer jeffarch...@gmail.com <jarch...@yahoo.com> On Thu, Oct 6, 2016 at 9:52 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > Jeff Archer wrote: > > Are there any performance or other considerations of the order of the > > fields for an insert? > > No; what matters is the order of columns in the table. > > > INSERT INTO mytable(wid1,cnt,dat,wid3,wid2) VALUES (?,?,?,?) > > - VS - > > INSERT INTO mytable(wid1,wid2,wid3,cnt,dat) VALUES (?,?,?,?) > > Both statements will result in exactly the same error. ;-) > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
