Yes, just change the row in some way(or insert a row), and it will insert the date automatically. (be sure to insert null in the timestamp field, or leave it out of your update query) I use the feature for many things.
Thanks dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 9:50 AM To: [EMAIL PROTECTED] Subject: Automatic timestamping Hi all, As I'm not very experienced with DB technology, I'm very sorry if my question seems stupid. I have set up a MySQL server as a central data repository where various clients are to write and read data concurrently. One of the attrbutes of the tables that are going to be managed by the MySQL is a TIMESTAMP. However, it is important to me that ALL clients use the same time source when they create records onto these tables. My question is: is it possible to use the clock of the MySQL machine as an unique time source for every table update ? I mean, can I simply leave to the MySQL server to automatically fill the TIMESTAMP attribute when new records are inserted ? Thnks for any help. F> Lucchese --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php