Please Help - Mysql Syntax Error

Hi,

I'm trying to create this table and here's the error I get:

I appreciate all your suggestions. Thanks

SQL query:

CREATE TABLE adtrackz_campaigns(

ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
groupID int( 11 ) ,
adcode varchar( 100 ) ,
url varchar( 255 ) ,
cost double default 0,
startdate datetime,
enddate datetime,
description varchar( 255 ) ,
purpose varchar( 10 ) ,
recurdays int( 5 ) ,
repeat int( 5 ) ,
ppc int( 1 ) ,
INDEX campaigns( ID )
)

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 'repeat int(5),
ppc int(1),
INDEX campaigns (ID)
)' at line 12

 

I just tried your query and it worked for me. I am using MySQL 4.1.21.
What is your MySQL version?

 

Sigh... repeat is a keyword.

If you want to have a hack for a solution, change that line to:

`repeat` int(5),

 

Yeah that worked on my previous server but my new server has mysql version 5.0.27.

KRT, I'll try your suggestion. Thankx

 

Hey KRT, that worked! Many Thanks