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
