Skip navigation links

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' 213641 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' 69540 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' 45435 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' 21544 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' 16667 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' 14795 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' 10654 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' 14195 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' 65614 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' 10638 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 21009 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 11003 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.