Answers for "mysql sql query to insert and update if exists"

MySQL update if exists else insert

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 sql query to insert and update if exists"