sql - Update multiple rows in a column in MySQL -


i'm having table that:

number 1   2   3   4   5  

i want change value in row 1 1 8, used

update tablea set number=8 number=1 

the resulting table looks follows:

number 8 2  3  4   5  

so far tried query below update multiple rows,

   update tablea set number=8 number=1;    update tablea set number=10 number=2;    update tablea set number=11 number=4; 

and works fine possible reduce simpler?

in query can this:

update tablea set number = number + 7 number in (1,4); update tablea set number=10 number=2; 

Comments

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

javascript - Using Windows Media Player as video fallback for video tag -

c# - Unity IoC Lifetime per HttpRequest for UserStore -