* Paul DuBois
> At 17:00 -0700 1/16/03, Matthew Phillips wrote:
> >I am running 3.23 and am new to mysql
> >
> >I would like to do something like this:
> >
> >delete t1
> >from t1, t2
> >where t1.col = t2.col
> >and ...
> >
> >basically deleting every row in t1 that has a matching row in t2.
> >
>
At 17:00 -0700 1/16/03, Matthew Phillips wrote:
I am running 3.23 and am new to mysql
I would like to do something like this:
delete t1
from t1, t2
where t1.col = t2.col
and ...
basically deleting every row in t1 that has a matching row in t2.
4.x has mechanisms to join 2 or more tables in upd
I am running 3.23 and am new to mysql
I would like to do something like this:
delete t1
from t1, t2
where t1.col = t2.col
and ...
basically deleting every row in t1 that has a matching row in t2.
4.x has mechanisms to join 2 or more tables in update and delete
statements, 3.x does not. Without
