Delete from table

[Anon]

Hi. I'm have the following query:

"DELETE p_categories FROM p_categories AS p, cat_main AS m, cat_sub AS s WHERE s.parent_id = m.parent_id AND m.parent_id = '$mid' AND p.cat_id = s.cat_id"

This is what it does:
I have a table with main categories, a tbl with subcategories and a tbl where each user's categories are listed. When i delete a main category i want to delete all the users listings, all the subcategories and then the main category.

This query works ok on MySQL 4.0.0 (tested locally) but not on previous versions. My server has 3.23.49 and i'm stuck.

Can anybody please tell me what to do, preferably if possible by NOT splitting the query.

Thanks.

John

[Anon]

There's a good reason for that, Mysql doesn't support multi-table deletes until 4.0.0, sorry 🙂

go to http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DELETE for more info.