26 Dec
2012
26 Dec
'12
4:07 p.m.
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