Answers for "mysql insert if exist then update value"

update item if id exists mysql

INSERT INTO tableName(id, NAME, score)
VALUES(1, "Fadl", 285)
ON DUPLICATE KEY
UPDATE NAME = "Fadl", score = 285

Posted by: Guest on May-24-2021

mysql insert exists update

INSERT INTO table (column_list)
VALUES (value_list)
ON DUPLICATE KEY UPDATE
   c1 = v1, 
   c2 = v2,
   ...;

Posted by: Guest on August-03-2020

Code answers related to "mysql insert if exist then update value"