Re: Updating multiple records with one statement

[Paul DuBois]

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