overwriting existing table value and auto increment value

Hi,

 I have a very simple table in a mysql database, which has the following columns,

id, tag, and count

The id column value is set to auto increment when I add a new value for tag and count. Instead of creating a new value each time for the column 'tag', is it possible to overwrite an existing value with the same value and then simply increase the value of count by 1.

eg: id =1. tag=world. count=20. If I then added the value 'world' again to the table, I would want to overwrite the previous value of count, and increase it by one to '21' and so on. Therefore, we would end up with a new row of id=1. tag=world, count=21 and so on. I don't mind if the id is changed, as long as the unique value for the tag, ie: 'world', is not replicated in the table.

Any help appreciated.

Thanks!
nhay59Asked:
Who is Participating?
 
steelseth12Connect With a Mentor Commented:
To update the existing column you would do
UPDATE tablename SET `count`=`count`+1, tag ='value' WHERE id=value_for_id (i.e 1)

to insert new row you would do

INSERT INTO  tablename SET `count`=`count`+1, tag ='value'

0
 
nhay59Author Commented:
Thanks for the solution. Spot on!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.