What's wrong with this SQL Query?

Status
Not open for further replies.

Derek

Community Support Force
Community Support
Messages
12,882
Reaction score
186
Points
63
I don't know what is wrong with it.. If someone can fix it I will give them 100 points..


#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 PACK_KEYS=0 AUTO_INCREMENT=1' at line 5

PHP:
CREATE TABLE `clans` (
  `clanName` varchar(20) NOT NULL default '',
  `clanPass` varchar(20) NOT NULL default '',
  `clanOwner` varchar(20) NOT NULL default '',
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;
 

DeadBattery

Community Support Team
Community Support
Messages
4,018
Reaction score
120
Points
0
Maybe the last comma on line 4 is messing it up?
 

Derek

Community Support Force
Community Support
Messages
12,882
Reaction score
186
Points
63
Lol thanks!!! Sending credits now.
 

DeadBattery

Community Support Team
Community Support
Messages
4,018
Reaction score
120
Points
0
You're Welcome!
I don't even know what the whole thing does. :biggrin:
 
Status
Not open for further replies.
Top