Sql queries

[kingarmy]

Can anyone help me? I've tried searching the forums, and google didn't give me precise answers.

-- Table structure for table `race_results`

--

CREATE TABLE `race_results` (

`rrID` int( 11 ) NOT NULL AUTO_INCREMENT ,

`rrTYPE` varchar( 255 ) NOT NULL default '',

`rrBET` int( 11 ) NOT NULL default '0',

`rrCHALLENGER` varchar( 255 ) NOT NULL default '',

`rrCHALLENGED` varchar( 255 ) NOT NULL default '',

`rrCHRCAR` varchar( 255 ) NOT NULL default '',

`rrCHDCAR` varchar( 255 ) NOT NULL default '',

`rrWINNER` varchar( 255 ) NOT NULL default '',

`rrNOTES` text NOT NULL ,

PRIMARY KEY ( `rrID` )

) ENGINE = MYISAM AUTO_INCREMENT =36 DEFAULT CHARSET = latin1 AUTO_INCREMENT =36;

 

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 '- phpMyAdmin SQL Dump

CREATE TABLE `race_results` (

`rrID` int(11) NOT' at line 1

[kingarmy]

Re: Sql queries

oh nvm, broken comment lol

[DELETE ME NOW!]

Re: Sql queries

So have you fixed it yes/no ?

[kingarmy]

Re: Sql queries

yup

[DELETE ME NOW!]

Re: Sql queries

Good :mrgreen: