Table entry error.

Discussion in 'Databases' started by locpicker, Mar 5, 2011.

  1. #1
    I am having a problem getting this to work in mysql. FOr some reason it is not valid anymore. Can anyone tell me how to fix it?

    
    --
    -- Table structure for table 'exigo'
    --
    
    CREATE TABLE exigo (
      id int(11) NOT NULL auto_increment,
      1 varchar(255) NOT NULL default '',
      2 varchar(255) NOT NULL default '',
      3 varchar(255) NOT NULL default '',
      4 varchar(255) NOT NULL default '',
      5 varchar(255) NOT NULL default '',
      6 varchar(255) NOT NULL default '',
      7 varchar(255) NOT NULL default '',
      8 varchar(255) NOT NULL default '',
      9 varchar(255) NOT NULL default '',
      10 varchar(255) NOT NULL default '',
      11 varchar(255) NOT NULL default '',
      12 varchar(255) NOT NULL default '',
      PRIMARY KEY  (id)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
     
    Code (markup):
    It throws an error when I try to do it.
     
    locpicker, Mar 5, 2011 IP
  2. Martin K

    Martin K Active Member

    Messages:
    262
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #2
    Did you try to name the columns with letters not with numbers?
     
    Martin K, Mar 6, 2011 IP
  3. locpicker

    locpicker Well-Known Member

    Messages:
    789
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    160
    #3
    The numbers work fine. What the problem was is the
    default ' '
    Code (markup):
    . I did away with that part and it did set up the table and accepted the input. Now I am wondering what other effect that this is going to have. It is from an old save.
     
    locpicker, Mar 6, 2011 IP