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
2009/12/10 Yuzem :
>
> 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
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 movi
Tim Romano wrote:
>
> 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.
>
Ok, I have thought about this and it will be probably simpler to have two
separated ids than using a trigger.
Now, there are some proble
You basically have this structure:
MOVIES movieid, title
PEOPLE peopleid, name
MOVIEPEOPLE movieid, peopleid, role
You insert a row into MOVIES and then insert one or more rows into
PEOPLE and then you want to associate people with a movie in your
MOVIESPEOPLE table. In order to do this, you
5 matches
Mail list logo