I've created a table that contains a column called "recordLastModified" and that column uses "timestamp" as the data type. Is there a way in MySQL to automatically update timestamp fields as records are modified? I want it to be nearly automatic in the same way that using "auto_increment" increases int data types, since that is faster than remembering to type numbers each time you add a new record. If not, how can I structure my insert or update statements to automatically capture the server's sytem time into the timestamp field, or am I required to manually include the date/time when I update a record?
Thanks. __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- 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