4 messages in com.mysql.lists.win32DEFAULT HOUR(NOW()) ?
FromSent OnAttachments
Ben Lion09 May 2002 10:08 
Joachim Schmidt09 May 2002 10:10 
Joachim Schmidt09 May 2002 10:16 
Paul DuBois13 May 2002 20:22 
Subject:DEFAULT HOUR(NOW()) ?
From:Ben Lion (lion@yahoo.ca)
Date:05/09/2002 10:08:22 AM
List:com.mysql.lists.win32

Hi, I am trying to create a table with one column having by default the actual hour of the day. the code looks like create table test (clock TIME, DEFAULT HOUR(NOW())); I get an SQL error. Is there a way to define a default like that in mysql?

I would be grateful if some one can give me a suggestions in this regard

Jochen