Page 1 of 1

delete record from multiple table using mysql 3++

Posted: Wed Aug 03, 2005 3:05 am
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

Posted: Wed Aug 03, 2005 3:06 am
by feyd
deletion from each table seperately..