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, 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 have seen it used
in some examples on the Internet (yes, I know, don't believe everything I
read). Will the table still auto number?
Dave,
Sent with [ProtonMail](https://protonmail.com) Secure Email.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users