Complicated delete

poring

Hey. I'm trying to make a delete query, but it won't work.

Here are two tables

tab_a

id
name

tab_b

id
blah

Now what I want to do is delete from the table tab_b all rows related to a given "name".
I tryed:

DELETE FROM tab_b
WHERE tab_a.name = '$name' AND tab_a.id = tab_b.id

It doesn't work. Can this be done at all?

Thanks

Natty_Dreadlock

maybe DELETE FROM tab_a, tab_b WHERE tab_a.name = '$name' AND tab_a.id = tab_b.id works, however, it's just an idea and i would test it before usin it in some real application...

poring

Nope, that doesn't work either.. 🙁

Natty_Dreadlock

no idea u should have a look at the mysql manual.... or wait for some mysql geek 😃

fox_m

Originally posted by poring
Hey. I'm trying to make a delete query, but it won't work.

Here are two tables

tab_a

id
name

tab_b

id
blah

Now what I want to do is delete from the table tab_b all rows related to a given "name".
I tryed:

DELETE FROM tab_b
WHERE tab_a.name = '$name' AND tab_a.id = tab_b.id

It doesn't work. Can this be done at all?

Thanks

This should work.

DELETE FROM tab_a, tab_b
USING tab_a ,tab_b
WHERE tab_a.id=tab_b.id
AND tab_a.name = $user

I have tested this by creating the 2 tables and insert one record which i have deleted now 🙂