Update multiple rows with different values in a single query - MySQL -

-

i'm new mysql.

i'm using update multiple rows different values, in single query:

update categories     set order = case id         when 1 3         when 2 4         when 3 5     end,     title = case id         when 1 'new title 1'         when 2 'new title 2'         when 3 'new title 3'     end id in (1,2,3)

i using "where" improve performance (without every row in table tested).

but if have senario (when don't want update title id 2 , 3):

update categories     set order = case id         when 1 3         when 2 4         when 3 5     end,     title = case id         when 1 'new title 1'     end id in (1,2,3)

the above code change title id 2 , 3 "null"...

what right way make query, skip updating title id 2 , 3 , still keep performance "where id in" gives ?

maybe this

update categories     set order = case id         when 1 3         when 2 4         when 3 5     end,     title = case id         when 1 'new title 1'         when           when       end id in (1,2,3)

set title equal when don't want update different value.

update categories     set order = case id         when 1 3         when 2 4         when 3 5     end,     title = case id         when 1 'new title 1'         else title     end id in (1,2,3)

Comments

Post a Comment

Popular posts from this blog

Python __call__ special method practical example -

-
i know __call__ method in class triggered when instance of class called. however, have no idea when can use special method, because 1 can create new method , perform same operation done in __call__ method , instead of calling instance, can call method. i appreciate if gives me practical usage of special method. django forms module uses __call__ method nicely implement consistent api form validation. can write own validator form in django function. def custom_validator(value): #your validation logic django has default built-in validators such email validators, url validators etc., broadly fall under umbrella of regex validators. implement these cleanly, django resorts callable classes (instead of functions). implements default regex validation logic in regexvalidator , extends these classes other validations. class regexvalidator(object): def __call__(self, value): # validation logic class urlvalidator(regexvalidator): def __call__(self, valu...
Read more

arrays - jQuery - Retrieve values from HTML elements and return their sum -

-
i got form several checkbox 's user can choose multiple values, so: <div> <input id="myinput1" type="checkbox" value="choice_id_1" /> <label for="myinput1">5</label> </div> <div> <input id="myinput2" type="checkbox" value="choice_id_2" /> <label for="myinput2">10</label> </div> <div> <input id="myinput3" type="checkbox" value="choice_id_3" /> <label for="myinput3">10</label> </div> i need values each :selected checkbox label , return total sum (ie: total = 25) . so far have been trying strings labels .text() method, make array results, converting them int parsefloat() , sum array elements... obviosly no success. this got (for sure not best approach i'm open diferent solutions) : function totalsum() { var prices = $("...
Read more