PHP PDO 语法错误或访问冲突:插入时为 1064
问题描述
我有一个表名板,我正在尝试使用当前代码插入数据
I have a table name boards, and I'm trying to insert data using the current code
但是,每次我收到此错误2012-05-11 14:40:50 : SQLSTATE[42000]: 语法错误或访问冲突:1064 您的 SQL 语法有错误;请查看手册对应于您的 MySQL 服务器版本,以便在 'desc,datecreated,isactive) 附近使用正确的语法 VALUES('d5989c7e-9b98-11e1-88cd-0026b936528c','1' at line 1"
However, every time I get this error "2012-05-11 14:40:50 : SQLSTATE[42000]: Syntax error or access violation: 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 'desc,datecreated,isactive) VALUES('d5989c7e-9b98-11e1-88cd-0026b936528c','1' at line 1"
我使用 bindValue()
尝试了相同的函数,只是将带有直接值的数组放入 $sth->execute()
函数中,但我总是收到同样的错误.也许外面的眼睛可以发现我遗漏或做错的事情?
I have tried the same function using bindValue()
and just putting the array with direct values into the $sth->execute()
function but I always receive the same error. Maybe an outside eye can spot something I'm missing or doing wrong?
推荐答案
将你的字段名称封装在反引号中 (`
),desc
是一个保留字.
Encapsulate your field names in backticks (`
), desc
is a reserved word.
这篇关于PHP PDO 语法错误或访问冲突:插入时为 1064的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!