maria-discuss team mailing list archive

[Eric Wood <eric@xxxxxxxxxxxxx>]

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