MariaDB 10.5

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

CREATE TABLE t (
  x int,
  inserted_at DATETIME DEFAULT CURRENT_TIMESTAMP ,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
insert into t (x) values (1)
select * from t

x
inserted_at
updated_at

1
2024-11-01 11:35:44
2024-11-01 11:35:44

select sleep(2) 

sleep(2)

0

update t set x = 2

Rows matched: 1  Changed: 1  Warnings: 0

select * from t

x
inserted_at
updated_at

2
2024-11-01 11:35:44
2024-11-01 11:35:46