double delete

[beckstei]

is there syntax for deleting from two tables at once: e.g.

delete from table1, table2 where table1.expire=current_date and table1.name=table2.name

thanks
B

[tomhath]

Mysql doesn't support that (in fact, I don't know of any dbms that would let you delete from more than one table in a single statement, although most others let you use a join or subselect).

Probably the best you can do is a select to identify the rows then delete from each in a while loop. I didn't test to see if you need to fetch all rows from the select before deleting them, although that's what the manual implies.

[[deleted]]

No.

And this is not required because 'real' databases (postgresql, oracle, informix, ms-sql) support primary-key/foreign-key relations with 'cascading delete'.

That means that whenever you delete a record that is refered to by other records, those refering records are also deleted.

MySQL sucks, why won't anybody believe me? 🙂

---

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[Anon]

Don't worry Vincent, nothing works to convince them like time and experience.