MySQL add days to a date

by

Assuming your field is a date type (or similar):

SELECT DATE_ADD(`your_field_name`, INTERVAL 2 DAY) 
FROM `table_name`;

With the example you’ve provided it could look like this:

UPDATE classes 
SET `date` = DATE_ADD(`date` , INTERVAL 2 DAY)
WHERE `id` = 161;

This approach works with datetime , too.

More Related Contents:

  1. Using LIMIT within GROUP BY to get N results per group?
  2. How to perform grouped ranking in MySQL
  3. Required to join 2 tables with their FKs in a 3rd table
  4. MySQL Trigger after update only if row has changed
  5. MySQL “WITH” clause
  6. Does COUNT(*) always return a result?
  7. Ordering by specific field value first
  8. MySQL “Group By” and “Order By”
  9. How to change the CHARACTER SET (and COLLATION) throughout a database?
  10. MySQL Query to select data from last week?
  11. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  12. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  13. Are there disadvantages to using a generic varchar(255) for all text-based fields?
  14. SQL Query to show nearest date?
  15. Convert partially non-numeric text into number in MySQL query
  16. MySQL “IN” operator performance on (large?) number of values
  17. How to get the latest record in each group using GROUP BY? [duplicate]
  18. MySQL Select last 7 days
  19. How do I count columns of a table
  20. Difference between two table structure
  21. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  22. How to retrieve JSON data from MySQL?
  23. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  24. Why MySQL is giving error “Not allowed to return a result set from a function”?
  25. When to use a left outer join?
  26. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  27. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. MySQL update statement to store ranking positions
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment