You do not need to set a default value if you want the current_timestamp.
Just leave the default option out when creating your table and the server
will do it for you.
CREATE TABLE COOKIE_REF (
cookie_ref varchar(50),
dat timestamp
);
OR
If you really want to put in a value for the default, use
CREATE TABLE COOKIE_REF (
cookie_ref varchar(50),
dat timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP
);
J.R.
-----Original Message-----
From: Scott Purcell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 4:30 PM
To: mysql@lists.mysql.com
Subject: default current_timestamp problem
Hello,
I am trying to create simple reference table for some cookies I am creating.
I wanted to put in a current_timestamp each time I do an insert so I can
delete this data after 2 or 3 weeks.
Here is the insert statement:
CREATE TABLE COOKIE_REF (cookie_ref varchar(50), dat timestamp default
current_timestamp)
I am trying to insert the below statement, but it fails with a 1064 Error
Code : 1064 You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'current_timestamp)' at line 1 (0 ms taken)
I am running version 4.0.15-max-debug on windows. and following this link
but It will not work. What can I be doing wrong?
http://dev.mysql.com/doc/mysql/en/datetime.html
Thanks,
Scott
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
