That is what I am using. Thanks for the pointer to the FAQ. Dave,
Sent with ProtonMail Secure Email. ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Monday, August 19, 2019 2:15 PM, Simon Slavin <slav...@bigfraud.org> wrote: > On 19 Aug 2019, at 6:56pm, dboland9 dbola...@protonmail.com wrote: > > > I have created a number of tables, and two of then are part of a many to > > many relationship. Thus, I need to get the last row id. Using the browser, > > What browser ? No part of the SQLite distribution is called a browser. > > > I find that: > > mytable_id INTEGER AUTO_INCREMENT PRIMARY KEY produces a null value > > mytable_id INTEGER PRIMARY KEY produces an integer value. > > So, AUTO_INCREMENT should not be used for a primary key? > > I think you have the right idea but a wrong syntax. > > https://sqlite.org/faq.html#q1 > > My guess is that you want > > mytable_id INTEGER PRIMARY KEY > > 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