Delete series of tables.. FK ?
Posted on 2010-04-02
I have 3 tables,
The flow of foreign key is like this
movies >> links >> link_set
id movie_id links_id
So I haven't set up foreign keys yet,
When I delete a movie from movies table, I want to delete the links (get from movie_id) and when links get deleted I link_set needs to get deleted (links_id). So can I do this with foreign key ? or do I need to write separate code for each delete job ?