for the table

I want all the columns to be incremented by 1 month

is there a function for this?

CodePudding user response：

You may add one day to your end dates, then take the last day of the resulting date:

SELECT id,
       start   INTERVAL 1 MONTH AS start,
       LAST_DAY(end   INTERVAL 1 DAY) AS `end`
FROM yourTable
ORDER BY id;

Demo

CodePudding user response：

If you are looking to update your table for permanently. You can use the below query

To update start column

update yourTable set start=date_add(start,interval 1 MONTH);

and to update end column

update yourTable set end=date_add(end,interval 1 MONTH);