July 30, 2012February 13, 2013 on MySQL tagged mysql add, mysql field add number, mysql update 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: UPDATE mysql_table SET user_id = 1000 + user_id;