Mysql update column + 1?

[jk2K]

how to build mysql resource query, like below?

UPDATE order SET                                      
    Order_Count = Order_Count + 100
  WHERE 
    Order_ID = '1234'

[Kabirdas]

Hey @jk2K!

That looks as though it should work are you running into any particular issues with it?

[jk2K]

the problem has been solved,

I thought I had to use GUI mode to write data, in fact, I can still use SQL mode