Re: Update Multiple records
| From: | Ariunbold Gerelt-Od | Date: | Thu, 17 May 2001 08:43:30 +0000 |
| Subject: | Re: Update Multiple records | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9400@lists.php.net to get a copy of this message | ||
I think , You should do following :
update weld_details set parent = '1' where db_uid = '1' or db_uid =
'2'
Ben Cairns wrote:
> I want to update a MySQL db table, but I want to update multiple records,
>
> Like this:
>
> I want to run a statement like this:
> update weld_details set parent = '1' where db_uid = '1','2'
>
> Now, it dont work, and I cant see why, I think it has something to do with the
> numbers at the end of the statement. But I cant see what...
>
> Pls help.
>
> Thanks in advance.
>
> -- Ben Cairns - Head Of Technical Operations
> intasept.COM
> Tel: 01332 365333
> Fax: 01332 346010
> E-Mail: BenC@intasept.com
> Web: http://www.intasept.com
>
> "MAKING sense of
> the INFORMATION
> TECHNOLOGY age
> @ WORK......"
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net