Routinely updating records with 20 or more columns can be exhausting
work. Many have asked for this for many years and I was hoping a
MariaDB developer would take the reins in implementing a shorter ON
DUPLICATE KEY UPDATE syntax:
INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY
UPDATE `a`=VALUES(`a`), `b`=VALUES(`b`), `c`=VALUES(`c`);
INSERT INTO `tableName` SET a=1, b=2, c=3 ON DUPLICATE KEY UPDATE a=1,
b=2, c=3;
INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY
UPDATE ASFORMENTIONED;
INSERT INTO `tableName` SET a=1, b=2, c=3 ON DUPLICATE KEY UPDATE
ASFORMENTIONED;
Something like this would certainly make SQL enjoyable again.
-Eric Wood
