OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
timestamp for update and insert

From: Hiep Nguyen (hiepee.ucr.edu)
Date: Tue Sep 04 2007 - 14:01:36 CDT

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