MySQL also has such a field type, but only the first timestamp field in a record that is not updated or has the value NULL assigned, will actually be automatically set. And you
can assign it also.
It seems however that this feature is subject to change, so you might want to check out to make sure. From the MySQL documentation:
The TIMESTAMP column type has varying properties and behaviour, depending on the MySQL version and the SQL mode the server is running in.
- TIMESTAMP behaviour when running in SAPDB mode
-
When MySQL is running in SAPDB mode, TIMESTAMP behaves like DATETIME. No automatic updating of TIMESTAMP columns occurs, as described in the following paragraphs. MySQL can be run in SAPDB mode as of version 4.1.1. See section 4.1.1 mysqld Command-line Options.
- TIMESTAMP behaviour when not running in SAPDB mode
-
The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically.
Liz