Missing something stupid on insert

Im wondering if someone can take a look at this simple INSERT statement
which is puking on me. I KNOW I must have something stupid in it that I am
NOT seeing, which will likely be obvious to someone . I'm enclosing the
statement, the error message, and the table structure. For some reason, this
eludes me. TIA, Ike

INSERT INTO statusactivities( activity, days, custom_date, repeat,
repeat_types, deleted, roll )
VALUES ( 6, 0, '2006-05-12', 0, 'Day(s)', 0, 0 )



#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,repeat_types,deleted,roll) VALUES (6,0,'2006-05-12',0,'D


CREATE TABLE `statusactivities` (
`id` int(11) NOT NULL auto_increment,
`status_or_associate_id` int(11) default NULL,
`status_is_associate` int(3) default NULL,
`activity` int(11) NOT NULL default '0',
`days` int(5) NOT NULL default '0',
`type` varchar(60) NOT NULL default '',
`custom_date` varchar(11) default NULL,
`repeat` int(3) default NULL,
`repeat_units` int(5) default NULL,
`repeat_types` varchar(30) default NULL,
`feedbackrequired` int(3) default NULL,
`deleted` int(3) NOT NULL default '0',
`designee` int(11) NOT NULL default '0',
`roll` int(3) default NULL,
`crossid` varchar(30) default NULL,
`tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `status_or_associate_id` (`status_or_associate_id`),
KEY `status_is_associate` (`status_is_associate`),
KEY `deleted` (`deleted`),
KEY `designee` (`designee`)
)

Re: Missing something stupid on insert

>Im wondering if someone can take a look at this simple INSERT statement
>which is puking on me.

MySQL does not support user-defined types of vomit.

>I KNOW I must have something stupid in it that I am
>NOT seeing, which will likely be obvious to someone . I'm enclosing the
>statement, the error message, and the table structure. For some reason, this
>eludes me. TIA, Ike
>
>INSERT INTO statusactivities( activity, days, custom_date, repeat,
>repeat_types, deleted, roll )
>VALUES ( 6, 0, '2006-05-12', 0, 'Day(s)', 0, 0 )
>
>#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,repeat_types,deleted,roll) VALUES (6,0,'2006-05-12',0,'D

If you can't find a good reason for the syntax error, suspect that
the column or table name in question is a keyword. Then backquote
it (`repeat`). In this case, `repeat` appears to be a keywoard.

Gordon L. Burditt

Re: Missing something stupid on insert

> If you can't find a good reason for the syntax error, suspect that
> the column or table name in question is a keyword. Then backquote
> it (`repeat`). In this case, `repeat` appears to be a keywoard.
>
> Gordon L. Burditt

Ah yes...that's it exactly. Thanks Gordon. -Ike