NYCPHP Meetup

[nycphp-talk] mySQL create table problem

Tim Gales tim_gales at email.msn.com
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 lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] 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!

 

Thanx

Phil

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030813/2b06c764/attachment.html>


More information about the talk mailing list