469,927 Members | 2,036 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

multi delete

Hi,

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?
Jun 14 '06 #1
1 1640
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;

Jun 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Gordon | last post: by
2 posts views Thread by Soldier | last post: by
4 posts views Thread by Andy_Khosravi | last post: by
4 posts views Thread by gambit32 | last post: by
2 posts views Thread by =?Utf-8?B?TU1TSkVE?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.