List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 16 2002 4:39pm
Subject:Re: Updating multiple records with one statement
View as plain text  
At 12:29 -0400 9/16/02, Peter D Bethke wrote:
>Hi all,
>
>I know this must be a rudimentary question, but I need to write an sql
>statement that will update several records from the same table, each record
>is unique and receives a unique value.
>
>Something like (but it doesn't work of course)

Correct.  It doesn't; you should use multiple statements.

>
>update mytable set myfield = "test" where id = "506" AND set myfield =
>"test2" where id = "519" AND ... Etc.
>
>Best,
>
>Peter

Thread
Updating multiple records with one statementPeter D Bethke16 Sep
  • Re: Updating multiple records with one statementPaul DuBois16 Sep