MySQL 8.0

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

select version();

version()

8.0.30

CREATE TABLE table_1 (
  id int not null auto_increment primary key
, create_dt datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
, val int
);
insert into table_1 (val) values (1)
select * from table_1;

id
create_dt
val

1
2023-08-28 14:17:52
1

select sleep(5);

sleep(5)

0

update table_1
    set val = 2;

Rows matched: 1  Changed: 1  Warnings: 0

select * from table_1;

id
create_dt
val

1
2023-08-28 14:17:57
2

select * from table_1

id
create_dt
val

1
2023-08-28 14:17:57
2