List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 29 1999 12:34am
Subject:Re: datetime now
View as plain text  
>I am trying to use MySql 9.33 Distrib 3.22.25, for pc-linux-gnu (i686).
>When I try this:
>create table projects (
>         projectid int auto_increment primary key,
>         userid int not null ,
>         name varchar(50),
>         visible bit default 'Y',
>         p_lastupdate datetime DEFAULT NOW() NOT NULL,
>         collapsed bit default 'N',
>         p_creatorid int
>I get this error:
>ERROR 1064 at line 1: You have an error in your SQL syntax near 'NOW NOT NULL,
>         collapsed bit default 'N',
>         p_creatorid int
>)' at line 6
>I have Mysql working fine. What is wrong? I want to default it to now.

You might want it to, but you can't.  That isn't supported.

Paul DuBois, paul@stripped
datetime nowUnknown Sender29 Jul
  • RE: datetime nowjim.cistaro29 Jul
  • Re: datetime nowPaul DuBois29 Jul