I would like to use INTEGER PRIMARY KEY, but I would like to disable
its implicit AUTOINCREMENT feature. Namely, if INSERT specifies value
of the column, I would like uniqueness to be enforced, but if NULL is
supplied, I would like the operation to fail instead of advancing key
to a new integer.
Switching declared type from INTEGER to INT should do what you want:
CREATE TABLE qqq (
id INT PRIMARY KEY
);
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users