1INSERT INTO table (column_list)
2VALUES (value_list)
3ON DUPLICATE KEY UPDATE
4 c1 = v1,
5 c2 = v2,
6 ...;
1INSERT INTO tableName(id, NAME, score)
2VALUES(1, "Fadl", 285)
3ON DUPLICATE KEY
4UPDATE NAME = "Fadl", score = 285
1INSERT IGNORE INTO companies
2 (id, full_name, address, phone_number)
3VALUES
4 (1, 'Apple', '1 Infinite Loop, Cupertino, California', 18002752273);
5