mysql field add number

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;

Newsletter

↑
  • Home
  • About Me
  • Contact Me