> i would like to create a Timestamp upon initial creation of a record. I > expected this could be done using now() in my INSERT statement but obv. the > related field gets actualised each time a record is updated. Unfortunately > that's not what i like - i would like to have the timestamp set just once > upon creation time without any changes later on. > How could this be done?
Frank, Use a datetime field instead, as it is not updated automagically. More about date and time column types: http://dev.mysql.com/doc/mysql/en/Date_and_time_types.html And more about timestamp behaviour prior to version 4.1: http://dev.mysql.com/doc/mysql/en/TIMESTAMP_pre-4.1.html and the behaviour in version 4.1 or later: http://dev.mysql.com/doc/mysql/en/TIMESTAMP_4.1.html Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
