Re: Unexplained MySQL Error..
| From: | John Pickett | Date: | Fri, 20 Jul 2001 20:28:01 +0000 |
| Subject: | Re: Unexplained MySQL Error.. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10612@lists.php.net to get a copy of this message | ||
Chris: The MySQL documentation would make you think so...
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]
Note there isn't a tbl_name [, tbl_name2, ...]. It's just tbl_name...
Cheers!
My 2 ¢
John Pickett
http://www.bvstudios.com/
Co-Author: Inside Dreamweaver 4
http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist
----- Original Message -----
From: "Boget, Chris" <Chris.Boget@wild.net>
To: "'Mike Gifford'" <mike@openconcept.ca>; <php-db@lists.php.net>
Sent: Friday, July 20, 2001 2:25 PM
Subject: RE: [PHP-DB] Unexplained MySQL Error..
> > UPDATE
> > WLPbib, WLPpublisher,WLPprofile,WLPbib2profile
>
> I think you can only update one table at a time...
> I could be wrong, though...
>
> Chris
>