MySQL中增加一列

Question

Zend 有没有办法将 MySQL 列中保存的整数加 1？

谢谢

编辑：

我当前的代码如下：

$row = $this->find($imageId)->current();
$row->votes = // THIS IS WHERE I WANT TO SAY INCREMENT
$row->save();

Answer 1

是的，有。以下是使用产品并递增数量字段的示例：

$table     = 'products'; 
$data      = array('prd_qnty' => new Zend_Db_Expr('prd_qnty + 1')); 
$where[] = $db->quoteInto('pr_id = ?', $this->pr_id); 
$db->update($table, $data, $where);

Answer 2

votes++ 不能防止其他请求的竞争条件，这就是为什么需要一个数据库解决方案。

例如：假设两个请求几乎同时到达

1st request loads object - votes is 500
2nd request loads object - votes is 500
1st increments value in memory - votes is 501
2nd increments value in memory - votes is 501
1st saves to db - votes is 501
2nd saves to db - votes is 501 (should be 502)

Answer 3

我可以提供以下建议吗

$row->votes++;