MySQL Forums
Forum List  »  InnoDB

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=InnoDB'
Posted by: Ryan Ward
Date: July 12, 2007 05:32AM

Hello All, Recently tried to most to a new hosting service for an old database, and well I set up the mysql database 4.1 and uploaded the imported old database.

I then recieved this error:

Error
SQL query:

CREATE TABLE race_skill_bonus(

race_id INTEGER NOT NULL ,
skill_category VARCHAR( 15 ) NOT NULL ,
skill_bonus_amount TINYINT UNSIGNED NOT NULL ,
INDEX ( race_id ) ,
FOREIGN KEY ( race_id ) REFERENCES races( race_id ) ,
PRIMARY KEY ( race_id, skill_category ) ,

) TYPE = InnoDB;



MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=InnoDB' at line 9


Any clue why this is coming up?

Options: ReplyQuote


Subject
Views
Written By
Posted
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=InnoDB'
272868
July 12, 2007 05:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.