By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

#1064 - You have an error in your SQL syntax;

nugology
P: 1
trying to upload a older .sql to myphpadmin and keep getting this any help would be nice...

Table structure for table `addedrequests`
--
Expand|Select|Wrap|Line Numbers
  1.  CREATE TABLE IF NOT EXISTS `addedrequests` (
  2.  
  3.  `id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
  4.  `requestid` int( 10 ) unsigned NOT NULL default '0',
  5.  `userid` int( 10 ) unsigned NOT NULL default '0',
  6.  PRIMARY KEY ( `id` ) ,
  7.  KEY `pollid` ( `id` ) ,
  8.  KEY `userid` ( `userid` ) ,
  9.  KEY `requestid_userid` ( `requestid` , `userid` ) 
  10. ) TYPE = MYISAM ;


MySQL said: Documentation
#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=MyISAM at line 27
Sep 8 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.