RE: [PHP-DB] sql querry problem

2002-05-03 Thread Ryan Jameson (USA)

That too... :-) You'll have to do two deletes, if your referential integrity is set up 
you'll have to delete the children before you can delete the parent as well.
Thanks Szii.. I missed that part.

<>< Ryan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 11:48 AM
To: andy
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] sql querry problem


"Delete from" does not work with multiple tables, AFAIK..

-Szii

- Original Message - 
From: "andy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] sql querry problem

2002-05-03 Thread szii

"Delete from" does not work with multiple tables, AFAIK..

-Szii

- Original Message - 
From: "andy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] sql querry problem

2002-05-03 Thread Ryan Jameson (USA)

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 
delete.

<>< Ryan

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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php