RE: repost timestamp for update & insert

2007-11-29 Thread Jerry Schwartz
age- > From: Hiep Nguyen [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 29, 2007 10:24 AM > To: mysql@lists.mysql.com > Subject: repost timestamp for update & insert > > i asked this question before, but when i tried what D.Vin suggested, i > got > an error. &g

RE: repost timestamp for update & insert

2007-11-29 Thread joe
CURRENT_TIMESTAMP ); -Original Message- From: Hiep Nguyen [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 8:24 AM To: mysql@lists.mysql.com Subject: repost timestamp for update & insert i asked this question before, but when i tried what D.Vin suggested, i got an error. m

repost timestamp for update & insert

2007-11-29 Thread Hiep Nguyen
i asked this question before, but when i tried what D.Vin suggested, i got an error. mysql version is 4.1.12 i tried: CREATE TABLE tbl_spdate( spdate_ID int NOT NULL PRIMARY KEY AUTO_INCREMENT , spdate_date date NOT NULL , spdate_notes varchar( 100 ) , spdate_created timestamp default 0, spdat