How do I add to each row in MySQL?

Question

We have a column that is a simple integer. We want to add to each row the value 10. How do we do it in sql for the MySQL database?

Actually we have another column that needs to do the same thing, and it is a date. We need to add a month to the date. How to do that?

Answer 1

 UPDATE table_name SET column_value = column_value + 10;

Answer 2

update table_name set column_name=column_name+10 where column_name is not null;

Answer 3

Should be something simple like this:

UPDATE some_table SET int_field = int_field + 10

Answer 4

Integers:

UPDATE table_name SET int_column_value = int_column_value + 10;
UPDATE table_name SET int_column_value = 10 WHERE int_column_value IS NULL;

Dates:

UPDATE table_name SET date_column_value = DATEADD(date_column_value, INTERVAL 1 MONTH);

More info: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_adddate