Dear SQLiters, I would like to use primary key as a way to create unique column entry:
CREATE TABLE A( id INTEGER PRIMARY KEY, fileName TEXT NOT NULL) such that file name is always prefix followed by the ID for the content to be: ID fileName 1 prefix_1 2 prefix_2 .... That is when I insert a row into the table, id is already auto generated by SQLite. I want the filename to be auto generated too. This idea looks strange to me because then I do not have to insert anything, everything will be auto filled: INSERT INTO A; INSERT INTO A; will insert first two rows. Roman _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
