why i am get error creating table

Discussion in 'MySQL' started by ironmankho, Feb 27, 2009.

  1. #1
    i am installing anti leech php script ....from this site

    when i am follow this guide

    i am getting this error

    Plese keep in mind i have little knowledge of database ...... any further guide very help full for me
     
    ironmankho, Feb 27, 2009 IP
  2. amerigohosting

    amerigohosting Peon

    Messages:
    255
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    try
    
    CREATE TABLE download_antileech(
    expiration varchar( 32 ) NOT NULL default '',
    INDEX int( 8 ) NOT NULL AUTO_INCREMENT ,
    KEY INDEX ( INDEX )
    );
    
    Code (markup):
     
    amerigohosting, Feb 27, 2009 IP
  3. ironmankho

    ironmankho Active Member

    Messages:
    393
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #3
    sorry it's not working

     
    ironmankho, Feb 27, 2009 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    Use this code

    CREATE TABLE download_antileech (
    expiration varchar(32) NOT NULL default '',
    `index` int(8) NOT NULL auto_increment,
    KEY `index` (`index`)
    ) TYPE=MyISAM; 
    Code (markup):
    index is a reserve word. To use reserve words in your query, you must use backticks around them.
     
    mwasif, Feb 28, 2009 IP
  5. ironmankho

    ironmankho Active Member

    Messages:
    393
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #5
    Thanks it is working .....
     
    ironmankho, Mar 1, 2009 IP
  6. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #6
    You are welcome!
     
    mwasif, Mar 1, 2009 IP