help, what's wrong with this code

[griffta]

can anyone tell me why mysql doesn't like this...
INSERT INTO MPM_op
(
OPID,
NUMID,
TEMPID,
VALID_OP,
USERID,
DATES,
CAT,
THIRD,
COREL,
COMMENTS,
OUT,
IMP,
ACCOUNT,
BALANCE,
PERIOD
)
VALUES('113581587416000','','1','1','113581587416','2005-12-29','2','113581587416000','0','Resume','0','0','113581587416000','0','0')

I get...
ERROR 1064 (42000): 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 'OUT,
IMP,
ACCOUNT,
BALANCE,
' at line 13

Thanks,

Matt

 

[r937]

OUT is a reserved word

try it in backticks, i.e. `OUT`

r937.com | rudy.ca

 

[johnwm]

There is a list of reserved words, and guidance on usage, at:

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller