MariaDB [test]> CREATE TABLE `ding` (
    ->   `id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    ->   `createdAt` DATETIME NOT NULL DEFAULT NOW(),
    ->   `updatedAt` DATETIME NOT NULL DEFAULT NOW(),
    ->   `zahl` INT NOT NULL
    -> );
Query OK, 0 rows affected (0.013 sec)

MariaDB [test]> CREATE OR REPLACE TRIGGER `ding_update_trigger` BEFORE UPDATE ON `ding` FOR EACH ROW SET NEW.`updatedAt`=NOW();
Query OK, 0 rows affected (0.011 sec)

MariaDB [test]> INSERT INTO `ding`(`zahl`) VALUES (1), (2), (3), (4);
Query OK, 4 rows affected (0.002 sec)
Records: 4  Duplicates: 0  Warnings: 0

MariaDB [test]> SELECT * FROM `ding`;
+----+---------------------+---------------------+------+
| id | createdAt           | updatedAt           | zahl |
+----+---------------------+---------------------+------+
|  1 | 2023-11-29 11:08:22 | 2023-11-29 11:08:22 |    1 |
|  2 | 2023-11-29 11:08:22 | 2023-11-29 11:08:22 |    2 |
|  3 | 2023-11-29 11:08:22 | 2023-11-29 11:08:22 |    3 |
|  4 | 2023-11-29 11:08:22 | 2023-11-29 11:08:22 |    4 |
+----+---------------------+---------------------+------+
4 rows in set (0.000 sec)

MariaDB [test]> DO sleep(10);
Query OK, 0 rows affected (10.001 sec)

MariaDB [test]> UPDATE `ding` SET `zahl` = 2 WHERE `zahl` = 2;
Query OK, 1 row affected (0.004 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [test]> UPDATE `ding` SET `zahl` = 4 WHERE `zahl` = 4;
Query OK, 1 row affected (0.002 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [test]> SELECT * FROM `ding`;
+----+---------------------+---------------------+------+
| id | createdAt           | updatedAt           | zahl |
+----+---------------------+---------------------+------+
|  1 | 2023-11-29 11:08:22 | 2023-11-29 11:08:22 |    1 |
|  2 | 2023-11-29 11:08:22 | 2023-11-29 11:08:32 |    2 |
|  3 | 2023-11-29 11:08:22 | 2023-11-29 11:08:22 |    3 |
|  4 | 2023-11-29 11:08:22 | 2023-11-29 11:08:32 |    4 |
+----+---------------------+---------------------+------+
4 rows in set (0.000 sec)