Add + 30000 to every column

x1mart posted 2 weeks ago in General

I have a table where my users are registered and there's a column called "bank" with their money. How can I add + 30000 in column "bank" to everyone?

ansgar posted 2 weeks ago

UPDATE users SET bank = bank plus 30000 (replace "plus" with the plus sign - cannot post here for some reason)

Please login to leave a reply, or register at first.