[thelist] [mysql] multiple update query

[kris burford]

> > is there a means i can do something like
> > update table set (foo='1' where id ='1'), (foo='2' where id='2');
>
>Perhaps not in one query, but using a temp table you may be able to pull
>this off...  Insert the data for the update into the temp table using the
>abbreviated syntax that you mentioned.
>
>Then, update the final table using the temp table as a source for the data.
>
>Then drop the temp table.

hi joshua,

okay. not sure i 100% understand what you're suggesting, but i *think* 
you're saying to do it by pulling the entire contents out of the original 
table (a), creating a new table (b), pushing all the old rows with the 
updated content into b, then deleting (or better yet, renaming) a and then 
renaming b to a's original name.

it'd work. but i've a feeling it's using a sledgehammer to crack a nut.

can't believe that there's not a simpler method...

anyway, thanks muchly for the help.

k