At 11:10 -0700 6/12/02, pixelandink.com wrote: >Hello, > >How does one create a MySQL table with a columns named something >like "creattime" and "modtime" where the creattime value for a >record is set to the current time when the record is created and the >modtime value for a record is set to the current time whenever the >record is modified?
Use two TIMESTAMP fields. The first one must be the modtime field and the second will be the createtime field. Set them both to NULL when the record is created. Don't set either when you modify the record. >Thanks, >David Franzen --------------------------------------------------------------------- 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
