MySQL Forums
Forum List  »  Newbie

How to refresh contents of a child table...
Posted by: Thomas Mahoney
Date: October 31, 2018 11:27AM

I have three tables in my Movies database: Titles, Actors, and Movies.

In my join table, Movies, I created two foreign keys, one linked to the field Title in Titles, and one linked to the field Name in Actors.

Here's the code...

create table Titles (
Title varchar(50) primary key,
Genre varchar(15) not null,
Actor varchar(30)
);

create table Actors (
Name varchar(30) primary key,
Movie varchar(50),
);

create table Movies (
Title varchar(50) references Titles(Title),
Genre varchar(15) references Titles(Genre),
ActorName varchar(30) references Actors(Name)
);

After filling the two parent tables, Titles and Actors, I notice that the child table, Movies, has not updated, despite the relationships. Is there a special command I must use to refresh my Movies table?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
How to refresh contents of a child table...
October 31, 2018 11:27AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.