you just need to increase the number in a particular cell, to do it through two requests seems to me a little expensive, is it possible to do this somehow through a 1-in request?

  • and how are you doing now? - Nord001 pm
  • I take a single request from the cell number, increase, then insert the second request, the meaning of the code to write? - Smash
  • to understand why you are "taking a number from a cell". - Nord001
  • then to increase. - Smash

1 answer 1

Something like that?

UPDATE catalog SET price = price * 1.05 WHERE category = 1 
  • one
    increase by 1, i.e. instead of * 1.05 I will put +1, thanks! - Smash
  • please :) - Nord001