Hello Guyzz,,

I need a help about to delete records simultaneously from 3 different tables in mysql

Here is my 3 tables structure with columns:

Category:

• catID
• cat_name

Artists:

• artID
• art_name
• catID

Song:

• songID
• s_name
• artID

What I am trying to do is, when I delete a record from 'category' table, it should delete those artists which have the same catID and then when an artist will be deleted, the songs under that artist which is also going to be deleted, should also deleted.

I can do this for two tables, like when I delete a record from cats table, it will auto delete a record from artists table, but i am confuse in the 3rd table that how can i do this in a single query.

I want to do this all in a single query. I can do this with individuals queries, but like professionals, i want to get all this done in a single query.

Please help me out in learning this.


Thanks in advance

Use the following query to delete from all the tables in single query

DELETE Category, Artists, Song 
FROM Category INNER JOIN Artists INNER JOIN Song 
WHERE Category.CatID = Artists.CatID 
AND Artists.artID = Song.artID
AND catID= ?