can you delete from multiple tables and if so what mysql version+ ?

[sfullman]

i tried this query and it failed:

DELETE FROM table1 a, table2b WHERE a.ID=b.table1ID AND a.ID='54'

this is just an example

but mysql won't accept it. Can't this be done? I'm running mysql 5.0.89 community

[johanafm]

Yes you can, assuming you use the correct syntax. Check the reference.

[johanafm]

Also, you can specify foreign key constraints with ON DELETE CASCADE if that's what you're after.

[sfullman]

I am aware of cascade delete and yes it's handy, this project is just not relational and the tables are myISam. But thanks, looking at the reference showed me where my query was wrong and it appears you can selectively delete this way.