NYCPHP Meetup

[nycphp-talk] mySQL create table problem

Phil Powell soazine at erols.com
Wed Aug 13 18:36:18 EDT 2003


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!

Thanx
Phil
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030813/73f2ce0a/attachment.html>


More information about the talk mailing list