trying to upload a older .sql to myphpadmin and keep getting this any help would be nice...
Table structure for table `addedrequests`
--
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
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