sql querry problem
| From: | andy | Date: | Fri, 03 May 2002 09:02:11 +0000 |
| Subject: | sql querry problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18960@lists.php.net to get a copy of this message | ||
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