* 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.
> >
> >4.x has mechanisms to join 2 or more tables in update and delete
> >statements, 3.x does not. Without upgrading, what are my options?
>
> None, using just SQL. You'll have to use a program that selects the
> relevant t1.col values, then use them to construct DELETE queries.
...and this program may be mysql...:
mysql -NB -e "SELECT CONCAT('DELETE FROM t1 WHERE col=',col,';') from t2"
dbname|mysql dbname
--
Roger
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
