Add an integer with a field value
Scenario: You have a field in database where you want to add it all with a number for example: 1000; you can update all of them like this:
|
1 |
UPDATE mysql_table SET user_id = 1000 + user_id; |
Scenario: You have a field in database where you want to add it all with a number for example: 1000; you can update all of them like this:
|
1 |
UPDATE mysql_table SET user_id = 1000 + user_id; |