MYSQL - Add specific time/day to given date



UPDATE tablename
SET field2 = date_add(field1,INTERVAL xx DAY);
Example :

UPDATE item_order set duedate = DATE_ADD(dateorder, INTERVAL 30 DAY);