Mysql update column + 1?

how to build mysql resource query, like below?

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

Hey @jk2K!

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

the problem has been solved,

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

1 Like