[nycphp-talk] mySQL create table problem

Phil Powell soazine at
Wed Aug 13 21:57:27 EDT 2003

fs_record_entered datetime default 'Now()'  worked!

  ----- Original Message ----- 
  From: louie 
  To: NYPHP Talk 
  Sent: Wednesday, August 13, 2003 10:01 PM
  Subject: Re: [nycphp-talk] mySQL create table problem

  TIMESTAMP DEFAULT 'now()' NOT NULL; //try this
    ----- Original Message ----- 
    From: Phil Powell 
    To: NYPHP Talk 
    Sent: Wednesday, August 13, 2003 3:36 PM
    Subject: [nycphp-talk] mySQL create table problem

    I am unable to determine which version of mySQL is running on a remote server (and the client doesn't know either, and I can't reach the host.. oh what I'll do for $80)...

    create table if not exists fs_usermetadata (
     fs_userid int not null,
     primary key(fs_userid),
     fs_username varchar(255) not null,
     fs_password varchar(255) not null,
     fs_user_category_id int not null,
     fs_user_firstname varchar(255),
     fs_user_lastname varchar(255),
     fs_user_address1 varchar(255),
     fs_user_address2 varchar(50),
     fs_user_city varchar(255),
     fs_user_state_province varchar(3),
     fs_user_zip_postal varchar(20),
     fs_user_country varchar(3),
     fs_user_homephone varchar(50),
     fs_user_workphone varchar(50),
     fs_user_fax varchar(50),
     fs_user_isHome varchar(1) not null,
     fs_user_ip varchar(15),
     fs_record_entered datetime default NOW(),
     fs_payment_method varchar(10) not null

    Can any of you determine why the fs_record_entered column call continually produces a SQL error? I am trying to set it to default to now() and it fails every time. Augh!



    talk mailing list
    talk at


  talk mailing list
  talk at
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the talk mailing list