mysql syntax error

[Rollo_Tamasi]

This mysql code

CREATE TABLE tblClickthroughRates(
id int (25) NOT NULL AUTO_INCREMENT ,
rate varchar (10) ,
PRIMARY (id)
) 

is rendering this error

#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 '(ID)
)' at line 4

mmmmm, why? 😕

[devinemke]

CREATE TABLE `tblClickthroughRates` (
`id` INT( 25 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`rate` VARCHAR( 10 ) NOT NULL 
);

[Houdini]

CREATE TABLE tblClickthroughRates(
id int (25) NOT NULL AUTO_INCREMENT ,
rate varchar (10) ,
PRIMARY KEY (id)
)
It should be PRIMARY KEY

[Rollo_Tamasi]

i can't believe i missed that, i have spent the last ten minutes wondering wtf was wrong
:o

[bradgrafelman]

Sometimes we just need a fresh pair of eyes (or two) 😉

Don't forget to mark this thread resolved!