List:General Discussion« Previous MessageNext Message »
From:Brad Scott Date:June 8 2010 6:45pm
Subject:Error 1064
View as plain text  

I am receiving this error:

ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to
you MySQL server version for the right syntax to use near '16 varchar(255) NOT NULL
default 'Not applicable', 17a varch

I have version 4.0.16 and have a dump file that I'm trying to recreate into a new
database.

The following is the table that is trying to be created along with some of the fields:


CREATE TABLE assessment_child_psych (
  id int(11) NOT NULL auto_increment,
  form_version smallint(6) NOT NULL default '1',
  client_id int(11) NOT NULL default '0',
  assessment_date datetime NOT NULL default '0000-00-00 00:00:00',
  user_id int(11) NOT NULL default '0',
  status varchar(20) NOT NULL default 'Pending',
  6a varchar(255) NOT NULL default 'Not applicable',
  6b varchar(255) NOT NULL default 'Not applicable',
  6c varchar(255) NOT NULL default '',
  7a varchar(255) NOT NULL default 'Not applicable',
  7b varchar(255) NOT NULL default '',
  7c varchar(255) NOT NULL default '',
  8a varchar(255) NOT NULL default 'Not applicable',
  9a varchar(255) NOT NULL default 'Not applicable',
  9 varchar(255) NOT NULL default 'Not applicable',
  9b varchar(255) NOT NULL default 'Not applicable',
  10a varchar(255) NOT NULL default 'Not applicable',
  10 varchar(255) NOT NULL default 'Not applicable',
  10b varchar(255) NOT NULL default '',
  10_describe varchar(255) NOT NULL default '',
  11a varchar(255) NOT NULL default 'Not applicable',
  11b varchar(255) NOT NULL default '',
  12a varchar(255) NOT NULL default 'Not applicable',
  12b varchar(255) NOT NULL default '',
  13a varchar(255) NOT NULL default 'Not applicable',
  13b varchar(255) NOT NULL default '',
  13b_other varchar(255) NOT NULL default '',
  14a varchar(255) NOT NULL default 'Not applicable',
  14b varchar(255) NOT NULL default '',
  14c varchar(100) NOT NULL default 'Not applicable',
  14cexplain varchar(255) NOT NULL default '',
  15a varchar(255) NOT NULL default 'Not applicable',
  15b varchar(255) NOT NULL default '',
  16 varchar(255) NOT NULL default 'Not applicable',
  17a varchar(255) NOT NULL default 'Not applicable',
  17b varchar(255) NOT NULL default '',

Any line beginning with just a number (ie 9, 10, 16) causes a failure.  What am I missing?


 		 	   		  
_________________________________________________________________
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1
Thread
Error 1064Brad Scott8 Jun
  • Re: Error 1064Mattia Merzi8 Jun
  • Re: Error 1064Carsten Pedersen8 Jun