samedi 25 avril 2015

how to make a multi delete query


Hello people i have a question about this query;

DELETE FROM 
 our_work, 
 our_work_images, 
 our_work_portf_img
WHERE 
 our_work.id = 6
AND 
 our_work_portf_img.portf_id = 6
AND
 our_work_portf_img.img_id = our_work_images.img_id;

i want to delete all relations from the first table "our_work" my pair table is named "our_wrok_porft_img" and my image table "our_work_images"


Aucun commentaire:

Enregistrer un commentaire