Re: UPDATE Query
| From: | Tony Harrison | Date: | Sun, 01 Sep 2002 09:48:11 +0000 |
| Subject: | Re: UPDATE Query | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-114820@lists.php.net to get a copy of this message | ||
What about multiple tables? Can that be done?
"Mark Charette" <charette@woodwind.org> wrote in message
news:ODEKKKOHBFKHBBNEGHMLKEDACBAA.charette@woodwind.org...
> No, only one db at a time may be updated. The "where" clauses can contain
> multiple db.
>
> -----Original Message-----
> From: Sascha Braun [mailto:saschabraun@gmx.de]
> Sent: Saturday, August 31, 2002 7:04 PM
> To: PHP Mailingliste
> Subject: [PHP] UPDATE Query
>
>
> I want to know if its possible to update two databases with one query?
>
> Please look at this example:
>
> UPDATE news_db, newsreferenz_db SET news_db.head = 'DFB Pokalasfasf',
> news_db.text = 'alkfhaslk fl akshf lakshf lkahs lfk aslf yxvyxvyxvyxv',
> newsreferenz_db.kat_id = '3' WHERE news_db.id = '6' AND
> newsreferenz_db.news_id = '6'
>
> it doesn't work.
>