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
Post a Comment