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
