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' 213415 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' 69485 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' 45389 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' 21528 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' 16656 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' 14779 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' 10643 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' 14179 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' 65580 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' 10630 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 20999 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 10996 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.