By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `table` (id SERIAL PRIMARY KEY, `datetime` DATETIME)
INSERT INTO `table` (`datetime`) VALUES
('2019-11-28 10:00'),
('2019-11-28 11:00'),
('2019-11-28 12:00'),
('2019-11-28 12:00'),
('2019-11-28 12:00'),
('2019-11-28 12:00'),
('2019-11-28 12:00'),
('2019-11-28 13:00'),
('2019-11-28 14:00')
SELECT *
FROM `table`
id | datetime |
---|---|
1 | 2019-11-28 10:00:00 |
2 | 2019-11-28 11:00:00 |
3 | 2019-11-28 12:00:00 |
4 | 2019-11-28 12:00:00 |
5 | 2019-11-28 12:00:00 |
6 | 2019-11-28 12:00:00 |
7 | 2019-11-28 12:00:00 |
8 | 2019-11-28 13:00:00 |
9 | 2019-11-28 14:00:00 |
UPDATE `table` t, ( SELECT MIN(id) AS N
FROM `table`
WHERE `datetime` = '2019-11-28 12:00' ) x
SET t.`datetime` = t.`datetime` + INTERVAL (t.id - x.N) MINUTE
WHERE t.`datetime` = '2019-11-28 12:00'
SELECT *
FROM `table`
id | datetime |
---|---|
1 | 2019-11-28 10:00:00 |
2 | 2019-11-28 11:00:00 |
3 | 2019-11-28 12:00:00 |
4 | 2019-11-28 12:01:00 |
5 | 2019-11-28 12:02:00 |
6 | 2019-11-28 12:03:00 |
7 | 2019-11-28 12:04:00 |
8 | 2019-11-28 13:00:00 |
9 | 2019-11-28 14:00:00 |