How to set the current date and time in a field with the DATETIME type for any creation and modification of a row using sql?

Question

MySQL

Now the field has:

`datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP

If a row is added to the table, then the current date and time will be set by default.
How to do the same when updating a row?

Answer 1

Create a trigger on Update in the database?