timestamp for update and insert

[Hiep Nguyen]

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