delete record from multiple table using mysql 3++

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
tkarven
Forum Commoner
Posts: 41
Joined: Tue Aug 02, 2005 10:26 pm

delete record from multiple table using mysql 3++

Post by tkarven »

hi,

how can we achieve this multiple table deletion in mysql version 3++ or older ? if it is mysql 4++, we can do so by :


Code: Select all

delete a,b from tablea a,tableb b where a.id = b.id
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

deletion from each table seperately..
Post Reply