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
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
