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
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
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