Tobias Vesterlund <tobias.vesterl...@ericsson.com> wrote: > I got a table in my database which looks like the following: > > A | B | C > 1 | 119 | 0 > 1 | 120 | 1 > 1 | 121 | 0 > 2 | 120 | 2 > 2 | 121 | 2 > > I want the A value to be generated for the bold rows (ie first inserts of > each 'linked' item) and I'd like to re-use the id > provided in the other rows.
This isn't going to work. For SQLite to automatically generate an ID, the column must be declared INTEGER PRIMARY KEY. But since it's necessarily a primary key, it won't allow duplicate values. > Is this possible or should I go with another way of structuring my database? You should go with another way of structuring your database. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
