[Maria-discuss] ASFORMENTIONED keyword suggestion
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
4308
Age (days ago)
4308
Last active (days ago)
0 comments
1 participants
participants (1)
-
Eric Wood