If you change from an auto increment to a GUID/UUID you can simply use 'REPLACE INTO' and you don't have to worry about the select, because you'll already know the ID.
http://www.sqlitetutorial.net/sqlite-replace-statement/ On Wed, Apr 26, 2017 at 4:05 PM, Joseph L. Casale <[email protected] > wrote: > From: sqlite-users [mailto:[email protected]] > On > Behalf Of David Raymond > Sent: Wednesday, April 26, 2017 3:00 PM > To: SQLite mailing list <[email protected]> > Subject: Re: [sqlite] Equivalent syntax in sqlite > > > With the comment that the insert or ignore method there will only work if > > there's an explicit unique constraint on your given criteria. > > Yup, the table does have one. Thanks for the help guys. > jlc > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
