By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE OHCL (
`id` INTEGER,
`index_minus` INTEGER,
`timestamp` INTEGER,
`year` INTEGER,
`month` INTEGER,
`day` INTEGER,
`hour` INTEGER,
`minute` INTEGER,
`close` FLOAT,
`MFA_short` VARCHAR(4),
`MFA_long` VARCHAR(4),
`volume` FLOAT,
`count` INTEGER
);
INSERT INTO OHCL
(`id`, `index_minus`, `timestamp`, `year`, `month`, `day`, `hour`, `minute`, `close`, `MFA_short`, `MFA_long`, `volume`, `count`)
VALUES
('1', '0', '1619743800', '2021', '4', '30', '2', '50', '0.3036', NULL, NULL, '97852.6', '41'),
('2', '1', '1619744100', '2021', '4', '30', '2', '55', '0.30358', NULL, NULL, '221278', '45'),
('3', '2', '1619744400', '2021', '4', '30', '3', '0', '0.303548', NULL, NULL, '41685', '30'),
('4', '3', '1619744700', '2021', '4', '30', '3', '5', '0.304009', NULL, NULL, '158091', '23');
Records: 4 Duplicates: 0 Warnings: 0
UPDATE OHCL o1
LEFT JOIN OHCL o2
ON o2.id = o1.id + 1
SET o1.timestamp = o2.timestamp,
o1.year = o2.year,
o1.month = o2.month,
o1.day = o2.day,
o1.hour = o2.hour,
o1.minute = o2.minute,
o1.close = o2.close,
o1.MFA_short = o2.MFA_short,
o1.MFA_long = o2.MFA_long,
o1.volume = o2.volume,
o1.count = o2.count;
Rows matched: 4 Changed: 4 Warnings: 0
SELECT * FROM OHCL;
| id | index_minus | timestamp | year | month | day | hour | minute | close | MFA_short | MFA_long | volume | count |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0 | 1619744100 | 2021 | 4 | 30 | 2 | 55 | 0.30358 | null | null | 221278 | 45 |
| 2 | 1 | 1619744400 | 2021 | 4 | 30 | 3 | 0 | 0.303548 | null | null | 41685 | 30 |
| 3 | 2 | 1619744700 | 2021 | 4 | 30 | 3 | 5 | 0.304009 | null | null | 158091 | 23 |
| 4 | 3 | null | null | null | null | null | null | null | null | null | null | null |