problem.....

[RaceAap]

Hi,

When I import a dump file created with mysqldump the following part:

CREATE TABLE s_menu (
id int(11) NOT NULL auto_increment,
description varchar(40) default NULL,
order int(11) NOT NULL default '1',
PRIMARY KEY (id)
) TYPE=MyISAM;

Generates:
ERROR 1064: You have an error in your SQL syntax near 'order int(11) NOT NULL default '1',
PRIMARY KEY (id)
) TYPE=MyISAM' at line 4

I don't understand why this part failes.. as other parts of the dump file do work correctly.

Anyone who knows why ??

Thanx in advance

Lon

 

[Bastien]

order is a sql keyword...change it to orders or some other word that is not a keyword

hth

Bastien

cat, the other other white meat

 

[RaceAap]

Thanks

that was indeed the problem.