Deleting multiple tables

[Anon]

It looks as though you can't do something like

delete from table1, table2, table3 where something = 'n';

in MySQL. Is this possible in other db's.

Just curious.

Later on,
BDKR

[[deleted]]

No and no, but 'real' databases use foreign-key constraints with cascading delete.

Simply put, that means that you can link two tables together by the value of one of their columns. If you delete a record from the 'parent' table that is being referenced by a (one or more) child table(s), the cascading delete will also remove the child record(s) automatically.

This is one of MySQL's biggest shortcomings;
you have to do all those checks manually.

---

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

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

[Anon]

I hear ya.

I've long been making plans for a conversion to Postgres anyways. This is just one reason to do so.

Later on,
BDKR