RE: default current_timestamp problem

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

Re: default current_timestamp problem

"Scott Purcell" <[EMAIL PROTECTED]> wrote on 06/07/2005 04:29:56 PM: > 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 sta

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 defaul