MySQL 8.0

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

SELECT @@version;

@@version

8.0.36

CREATE TABLE foo (
    id INT(10) UNSIGNED NOT NULL,
    what_time TIME NOT NULL DEFAULT (CURTIME()),
    PRIMARY KEY (id)
);
INSERT INTO foo (id) VALUES (1);
SELECT SLEEP(2);

SLEEP(2)

0

INSERT INTO foo (id) VALUES (2);
SELECT * FROM foo;

id
what_time

1
09:27:17

2
09:27:19