NYCPHP Meetup

[nycphp-talk] mySQL create table problem

Phil Powell soazine at erols.com
Wed Aug 13 21:56:57 EDT 2003


I tried, that failed too:

select version() LIMIT 0, 30

MySQL said: 


You have an error in your SQL syntax near 'LIMIT 0, 30' at line 1

Back 

I didn't put "LIMIT 0, 30" in my query, that was somehow embedded

Phil
  ----- Original Message ----- 
  From: Tim Gales 
  To: 'NYPHP Talk' 
  Sent: Wednesday, August 13, 2003 8:05 PM
  Subject: RE: [nycphp-talk] mySQL create table problem


  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



------------------------------------------------------------------------------


  _______________________________________________
  talk mailing list
  talk at lists.nyphp.org
  http://lists.nyphp.org/mailman/listinfo/talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030813/4815e23d/attachment.html>


More information about the talk mailing list