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.
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.