MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1 (id INT UNSIGNED PRIMARY KEY, `time` DATETIME, value INT);
CREATE TABLE table2 (id INT UNSIGNED PRIMARY KEY, `last_value` INT);

INSERT INTO table1 VALUES
  (1, '2024-01-09 22:24:14', 100),
  (2, '2024-01-10 22:25:14', 200),
  (3, '2024-01-11 22:26:14', 300);

INSERT INTO table2 VALUES (1, NULL);

Records: 3  Duplicates: 0  Warnings: 0

SELECT * FROM table1;
SELECT * FROM table2;

id
time
value

1
2024-01-09 22:24:14
100

2
2024-01-10 22:25:14
200

3
2024-01-11 22:26:14
300

id
last_value

1
null

UPDATE table2
SET `last_value` = (SELECT value FROM table1 ORDER BY `time` DESC LIMIT 1)
WHERE id = 1;

Rows matched: 1  Changed: 1  Warnings: 0

SELECT * FROM table1;
SELECT * FROM table2;

id
time
value

1
2024-01-09 22:24:14
100

2
2024-01-10 22:25:14
200

3
2024-01-11 22:26:14
300

id
last_value

1
300

id	time	value
1	2024-01-09 22:24:14	100
2	2024-01-10 22:25:14	200
3	2024-01-11 22:26:14	300