我的代码在插入数据库的代码行中抛出错误Error in mysql syntax
。当我回显插入时,我得到
INSERT INTO patches (
name,
description,
type,
com1,
com2,
com1,
code,
db,
other,
tfsID,
release,
createdBy,
createdDtTm,
updatedBy,
updatedDtTm
) VALUES (
'testPatch2',
'longPatchDescription',
'Code - Full Build',
'0',
'1',
'1',
'0',
'1',
'1',
'98765',
'6.11.0',
'mhopkins',
'2013/06/26 08:58:19',
'mhopkins',
'2013/06/26 08:58:19'
)
我相信我的语法还可以。但我很困惑为什么我不能得到更多关于这个错误的数据。想法?
准确错误
Errormessage: 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 'release, createdBy, createdDtTm, updatedBy, updatedDtTm) VALUES ('testPatch2','l' at line 1
MySQL保留字列表如下:http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html