Y
Hacker News
new
|
ask
|
show
|
jobs
by
eternalvision
3275 days ago
With MySQL, there's a fairly simple trick you can do to build a queue. Set a temp var to null, run an update with a select subquery to update state of next row(s), then select that var to get your queue row pk's.