4 ms·
Note of care: SQL Updates are not idempotent. "UPDATE table SET a = a + 1".
by Xylakant 14y ago
Note of care: SQL Updates are not idempotent. "UPDATE table SET a = a + 1".
- nfriedly 14y agoI love that for rearranging items in lists with user-defined orders. It lets you update the entire set with two commands - one to give the moved item its new position, and one to increase the position of every item after it.