the ansi syntax for delete is "delete from table where ???"
You don't tell it what to delete since it will always delete whole rows.
So just remove o.* .

If you are in need of setting a field to blank you'll have to use an update, not a 

<>< Ryan

-----Original Message-----
From: andy [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 3: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 (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to