MySQL - 在反引号中将名称添加1到列

Question

I'm having trouble adding 1 to a column value in MySQL. I've used backticks on the column name and value isn't incrementing. Here is my query:

$update = $connectdb->prepare("UPDATE `strings` SET posted=posted, `response-comment`=`response-comment` + 1 WHERE `id`=?");
$update->execute(array($id));   

Why isn't my query working? The value $id is correct, the column response-comment should increase by 1.

Answer 1

Try using this for your SQL statement (presuming strings is the name of your table:

UPDATE `strings` SET `response-comment`=`response-comment` + 1 WHERE `id`=?