using addition in a MySQL table row?

Question

How to update value "100" If the $id duplicate by adding +100 to it so the total will be 200 in the level here is my INSERT statement

  INSERT INTO users (id, name, level) VALUES ($id, 'name', 100 )

Fluffeh · Accepted Answer · 2012-09-11 08:06:51Z

2

This should do the trick for you (I am assuming that id is a unique field and can be used to identify the correct row to update):

$query="INSERT INTO 
users (id, name, level) 
VALUES ($id, 'name', 100 ) 
on duplicate key 
    update set level=level+100";

answered Sep 11, 2012 at 8:06

Fluffeh

33.6k16 gold badges69 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Christoph Grimmer · Accepted Answer · 2012-09-11 08:13:39Z

0

Since UPDATE is MySQL specific the more generic way is to do INSERT INTO users (id,name,level) VALUES ($id, 'name', 100) ON DUPLICATE KEY UPDATE level = level + VALUES(level)

See http://dev.mysql.com/doc/refman/5.1/de/insert-on-duplicate.html AFAIK this is more generally applicable then only on MySQL.

answered Sep 11, 2012 at 8:13

Christoph Grimmer

4,3434 gold badges43 silver badges66 bronze badges

Collectives™ on Stack Overflow

using addition in a MySQL table row?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related