update multiple rows having diff condition in one go 1

[Zoom1234]

Hello,

I have to do update operation to the set of records
e.g.

update tablename set value=100 where id=1;
update tablename set value=200 where id=2;
update tablename set value=300 where id=3;
update tablename set value=400 where id=4;

I tried pasting all the statements in query browser but only one statement gets executed. How can I update this bunch of records in one go.

Thanks.

 

[feherke]

Hi

Personally I recommend using your multiple [tt]update[/tt] statements. Will be easier to read/debug/modify them later.

[b]update[/b] tablename
[b]set[/b] value[teal]=[/teal]case id
  when [purple]1[/purple] then [purple]100[/purple]
  when [purple]2[/purple] then [purple]200[/purple]
  when [purple]3[/purple] then [purple]300[/purple]
  when [purple]4[/purple] then [purple]400[/purple]
end
[b]where[/b] id [b]in[/b] [teal]([/teal][purple]1[/purple][teal],[/teal][purple]2[/purple][teal],[/teal][purple]3[/purple][teal],[/teal][purple]4[/purple][teal]);[/teal]

Feherke.

http://free.rootshell.be/~feherke/

 

[Zoom1234]

Hi Feherke,
Thanks.