add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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