MySQL Forums :: 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'


Advanced Search

#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' 240640 Ryan Ward 07/12/2007 05:32AM
Re: #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' 74292 John Dzilvelis 07/12/2007 10:39AM
Re: #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' 49073 Ryan Ward 07/17/2007 06:45PM
Re: #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' 22790 KimSeong Loh 07/18/2007 07:36AM
Re: #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' 17678 Ryan Ward 07/18/2007 10:42AM
Re: #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' 15735 Kenneth Moses 07/18/2007 10:58AM
Re: #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' 11398 Ryan Ward 07/19/2007 01:28PM
Re: #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' 15373 Parvesh Garg 07/22/2007 05:17AM
Re: #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' 67729 DeMuth Flake 10/30/2007 07:05AM
Re: #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' 11264 KimSeong Loh 10/31/2007 02:52AM
#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 'reset NOT NULL, PRIMARY KEY (`contactid`))' at line 26 21930 Brian Carlos 01/21/2008 11:30AM
Re: #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 'reset NOT NULL, PRIMARY KEY (`contactid`))' at line 26 11797 KimSeong Loh 01/21/2008 07:14PM


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.