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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nugology
    New Member
    • Sep 2013
    • 1

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

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

    Table structure for table `addedrequests`
    --
    Code:
     CREATE TABLE IF NOT EXISTS `addedrequests` (
    
     `id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
     `requestid` int( 10 ) unsigned NOT NULL default '0',
     `userid` int( 10 ) unsigned NOT NULL default '0',
     PRIMARY KEY ( `id` ) ,
     KEY `pollid` ( `id` ) ,
     KEY `userid` ( `userid` ) ,
     KEY `requestid_userid` ( `requestid` , `userid` ) 
    ) 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
    Last edited by Rabbit; Sep 9 '13, 05:01 PM. Reason: Please use code tags when posting code or formatted data.
Working...