MySQL Database installation error , code synax error.

Discussion in 'MySQL' started by stefanlyl, Dec 14, 2008.

  1. #1
    i got this error while trying to upload the database , any help?


    SQL query: 
    
    TABLE `game_cheats` (
    
    `CheatID` int( 10 ) NOT NULL AUTO_INCREMENT , `CheatTitle` varchar( 255 ) NOT NULL default '', `CheatCategory` int( 10 ) NOT NULL default '0', `CheatSubcategory` char( 2 ) NOT NULL default '0', `CheatText` text NOT NULL , `PageViews` int( 11 ) NOT NULL default '0', PRIMARY KEY ( `CheatID` ) 
    );
    
    
    
    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 'TABLE `game_cheats` (
      `CheatID` int(10) NOT NULL auto_increment,
      `CheatTit' at line 1 
    
    Code (markup):

     
    stefanlyl, Dec 14, 2008 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    put a create before table
     
    crivion, Dec 14, 2008 IP