Add + 30000 to every column

1 posts
[expired user #12121]'s profile image [expired user #12121] posted 5 years ago in General Permalink

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?

10150 posts
ansgar's profile image ansgar posted 5 years ago Permalink

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.