delete record from multiple table using mysql 3++
Posted: Wed Aug 03, 2005 3:05 am
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 :
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