3 ms·
I'd really like a "LIMIT x" option for updates when initializing new columns. Updating all rows can lock reading forever, so I'd like to do: loop UP
by silvestrov 5y ago
I'd really like a "LIMIT x" option for updates when initializing new columns.
Updating all rows can lock reading forever, so I'd like to do:
loop
UPDATE items SET last_update = now() WHERE last_update IS NULL LIMIT 10000
commit
until no rows modified