MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:J.R. Bullington Date:June 7 2005 8:49pm
Subject:RE: default current_timestamp problem
View as plain text  
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:spurcell@stripped] 
Sent: Tuesday, June 07, 2005 4:30 PM
To: mysql@stripped
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: user-unsubscribe@stripped
For additional commands, e-mail: user-help@stripped


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


Thread
default current_timestamp problemScott Purcell7 Jun
  • Re: default current_timestamp problemSGreen7 Jun
  • RE: default current_timestamp problemJ.R. Bullington7 Jun