03.08.2018, 13:10
2) https://dev.mysql.com/doc/refman/8.0...duplicate.html
Does inventory table have a primary key? If not, set these two (userid, itemid) as PRIMARY KEY. Each player and item is a unique pair and use the syntax I linked above. It either inserts a new row or updates the row if exists.
Does inventory table have a primary key? If not, set these two (userid, itemid) as PRIMARY KEY. Each player and item is a unique pair and use the syntax I linked above. It either inserts a new row or updates the row if exists.