About deleting multiple rows from multiple columns: In the top of the 'DELETE definition page' on http://www.mysql.com/ a paragraph states that DELETE table1,table2 FROM table1,table2,table3 WHERE table1.id=table2.id AND table2.id = table3.id AND table3.val = 'somevalue' would delete the corresponding rows from table1 and table2. I tried it in different settings (also using the USING clause), but couldn't get it to work. After searching I found this page: http://www.mysql.com/doc/D/e/Deleting_from_related_tables.html which states that it isn't possible to delete from more than one table.... Grrrr
Does anybody have a clue or workaround?
Regs, Jason
It is neither possible nor deisrable to delete rows from more than one table at a time.
Use multiple queries and CHECK wether each delete was successful before you do the next.
A forum, a FAQ, email notification, what else do you need?
The documentation on http://www.mysql.com says that you can delete from multiple tables if you have mysql 4.0 and up.
