Re: sql querry problem
| From: | szii at sziisoft dot com | Date: | Fri, 03 May 2002 17:48:27 +0000 |
| Subject: | Re: sql querry problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18969@lists.php.net to get a copy of this message | ||
"Delete from" does not work with multiple tables, AFAIK..
-Szii
----- Original Message -----
From: "andy" <news.letters@gmx.de>
To: <php-db@lists.php.net>
Sent: Friday, May 03, 2002 2:02 AM
Subject: [PHP-DB] sql querry problem
> Hi there,
>
> I do have 2 tables. One contains an update for the other one. Before
> inserting I would like to delete all the entries in the old table containing
> the same country_code like one in the new table.
>
> I tryed:
>
> delete o.*
> from Cities_update_imported n, test.cities o
> where n.country_code = o.country_code
>
> But does not work though:-(
>
> can anybody help on that?
>
> thanx, Andy
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php