Question : insert or update mysql
Answered by : thomas-naccari
/*UNDER THE HOOD THIS IS A DELETE, YOU NEED TO INSERT ALL FIELDS*/
REPLACE INTO table1 (id, name, age) VALUES(1, "A", 19)
/*THIS IS THE TURE INSERT OR UPDATE*/
INSERT INTO table1 (id, name, age) VALUES(1, "A", 19) ON DUPLICATE KEY UPDATE name="A", age=19
Source : | Last Update : Sun, 11 Sep 22
Question : mysql insert exists update
Answered by : lovely-lyrebird-7guk1jzjtm90
INSERT INTO table (column_list)
VALUES (value_list)
ON DUPLICATE KEY UPDATE c1 = v1, c2 = v2, ...;
Source : https://www.mysqltutorial.org/mysql-insert-or-update-on-duplicate-key-update/ | Last Update : Mon, 10 Aug 20
Question : mysql on duplicate key update
Answered by : mahdi-amirimatin
INSERT INTO t1 (a,b,c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE c=3;
INSERT INTO t1 (a,b,c) VALUES (4,5,6) ON DUPLICATE KEY UPDATE c=9;
Source : https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html | Last Update : Wed, 04 Nov 20
Question : mysql update add to existing value
Answered by : andrew-hyder
mysql> UPDATE tableName SET sometotal = sometotal+10 WHERE Id = 4;
Source : https://www.tutorialspoint.com/how-to-update-field-to-add-value-to-existing-value-in-mysql | Last Update : Tue, 04 Aug 20
Question : update having mysql
Answered by : kamal-prihandani
UPDATE contacts_domains cd, (SELECT id FROM contacts_domains GROUP BY domain_id HAVING COUNT(contact_id) = 1) AS cdtmp
SET cd.dominant = 1
WHERE cd.id = cdtmp.id
Source : https://stackoverflow.com/questions/8127257/mysql-update-subset-having | Last Update : Sat, 31 Oct 20