SQL syntax error

[PaulStat]

What's wrong with this, I can't see it?

self._cursor.execute("""INSERT INTO CHANNELPROGRAMME(CHANNELID,PROGRAMMEID,
                             EPISODEID,REPEAT,
                             NEWSERIES,PREMIERE,
                             CHOICE,SUBTITLES,
                             DEAFSIGNED,DATE,
                             STARTTIME,ENDTIME,DURATION) 
                             VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)""",
                             (channelID,progId[0],epId,
                             tempDict["REPEAT"],tempDict["NEWSERIES"],
                             tempDict["PREMIERE"],tempDict["CHOICE"],
                             tempDict["SUBTITLES"],tempDict["DEAFSIGNED"],
                             formatDate,tempDict["STARTTIME"],
                             tempDict["ENDTIME"],tempDict["DURATION"]))

I keep getting the following error

_mysql_exceptions.ProgrammingError: (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,NEWSERIES,PREMIERE,CHOICE,\n SUBT' at line 1")

 

[PaulStat]

REPEAT is a MySQL reserved word iirc.

thanks yes I just found that out, using `REPEAT` fixes it