4 ms·
How about UPDATE LIMIT 1 instead of fancy edge case features?
by rezoner 7y ago
How about UPDATE LIMIT 1 instead of fancy edge case features?
- other_herbert 7y agoI'm curious why you need this? As a safety mechanism? You could just do a select with the limit then update that row from the primary key...
- lucb1e 7y agoSure, with a Turing compete system everything is a "you could just". It seems a lot easier to update limit 1 than to involve a subquery. If that is what GP meant it for, of course.
- ratiolat 7y agoUPDATE LIMIT 1 is an edge case