Increment a column in MySQL

Question

Is there a way in Zend to increment an integer, held in a MySQL column, by 1?

Thanks

edit:

My current code is like:

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

Do you mean Zend Framework? If so, which component? Zend_Db, Zend_Db_Table, something else? — Phil, Mar 23 '11 at 04:32

RDL · Answer 1 · 2011-03-23T04:54:19.360

19

Yes there is. Here's an example using products and incrementing a quantity field:

$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);

edited Mar 23 '11 at 04:54

answered Mar 23 '11 at 04:47

RDL

7,865
3
29
32

Is the downvote for my old answer or new one? I'm pretty sure the new one is correct, no? – RDL Mar 23 '11 at 04:56
Yes, `$row->votes++;` would be the way to go. In future it helps to show related code in your question so we can guide you to the best possible solution. – RDL Mar 23 '11 at 05:14

score 5 · Answer 2 · answered Sep 27 '11 at 22:39

votes++ does not protect against race conditions from other requests, that's why it is desirable to have a database solution.

For example: imagine two requests come in at almost the same time

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)

score 0 · Accepted Answer · answered Mar 23 '11 at 05:09

0

Might I offer the following suggestion

$row->votes++;

answered Mar 23 '11 at 05:09

Phil

157,677
23
242
245

A very simple solution. Thanks. – edwinNosh Mar 23 '11 at 05:10
2

This suffers from a race condition between connections and is a bad solution. – Justin Swanhart Aug 03 '12 at 23:01

Increment a column in MySQL

3 Answers3

Linked