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

Reply via email to