MySql inserting value or increment a field

Question

I have a table with these columns: Player_name | Item_name | Amount

I do not know how to perform this conditional INSERT:

INSERT INTO Needed_items(Player_name,Item_name) VALUES('foo','foo');

if Player_name and Item_name already exist, so if a Player already owns a given item, I need to increment Amount field, else I need to insert a new row into the table. Thanks for the help

That's my whole code, I have no idea how to write those conditions in mySQL language — Luca Maltagliati, Dec 11 '16 at 17:42
Have you checked http://stackoverflow.com/questions/913841/mysql-conditional-insert? — Guriandoro, Dec 11 '16 at 18:21
@Guriandoro yes, but it didn't help me, I don't have unique columns in my table — Luca Maltagliati, Dec 11 '16 at 19:49

score 0 · Answer 1 · answered Dec 11 '16 at 18:31

0

Try something like this:

INSERT INTO Needed_items(Player_name,Item_name) VALUES('foo','foo')
ON DUPLICATE KEY UPDATE Amount=Amount+1

answered Dec 11 '16 at 18:31

monami

594
2
8
29

It doesn't work for me. It just adds another row to the table without incrementing anything – Luca Maltagliati Dec 11 '16 at 19:52
So you don't have unique items in the table. Can you give your create table syntax? – monami Dec 11 '16 at 20:34

MySql inserting value or increment a field

1 Answers1