You should keep your id and the imdbid in separate columns, because you can then insert a title even if IMDB does not have it yet.
id INTEGER PRIMARY KEY imdbid integer // you should allow this column to be null title not null, et cetera Regards Tim Romano Yuzem wrote: > CREATE TABLE movies(id integer,title text,unique(id)) > > Generally I have an unique id from imdb but some times the movie isn't > available. > I understand that there is a column called rowid that is the primary key. > I would like to insert the rowid on the id column when I don't have an id > for the movie. > > Example: > insert into movies values(rowid,'title1'); > > How can I do that? > > > > ------------------------------------------------------------------------ > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.426 / Virus Database: 270.14.101/2555 - Release Date: 12/09/09 > 19:41:00 > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users