[nycphp-talk] mySQL create table problem

Tim Gales tim_gales at
Wed Aug 13 20:05:02 EDT 2003

Regarding determining which version of mySQL the client is using:


Can you use a query like 'select version()'  


On the datetime type - can you use a timestamp which would automatically be
set to the system date/time



-----Original Message-----
From: talk-bounces at [mailto:talk-bounces at] On
Behalf Of Phil Powell
Sent: Wednesday, August 13, 2003 6:36 PM
To: NYPHP Talk
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!




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the talk mailing list