I would use a trigger (at least for the update).... The first insert should work with now() and you can leave lastupdateted empty
Olaf On 9/4/07 3:01 PM, "Hiep Nguyen" <[EMAIL PROTECTED]> wrote: > Hi list, > > i tried to create a table with inserted & lastupdated timestamp fields: > > create table temp ( > id int not null primary ke auto_increment, > data varchar(100), > inserted timestamp default now(), > lastupdated timestamp(8)); > > > how do i get mysql to put in the current timestamp for inserted & > lastupdated fields when i insert a record and only lastupdated when i > update the record? > > thanks, > T. Hiep > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]