On Wed, 31 Jul 2002 [EMAIL PROTECTED] wrote: > Date: Wed, 31 Jul 2002 12:49:35 -0300 > From: [EMAIL PROTECTED] > 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. If you have a single timestamp type column in a table and do not assign it a value it will be given the server's time when last created or updated. This is exactly what the type is designed to do.
> > 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 > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 --------------------------------------------------------------------- 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
