multi delete

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I have MySQL 5.0.22 and I can't seem to do multiple delete 100% on InnoDB
table with Foriegn Key.

What should the correct syntax be?

Re: multi delete

Found what I want - was USING + RIGHT OUTER

DELETE FROM `sale-equip`,`sale-rooms` USING `sale-equip`
RIGHT OUTER JOIN `sale-rooms` ON `sale-rooms`.id = `sale-equip`.idsale
WHERE `sale-rooms`.id = 64;

Site Timeline