medium10 pts · first answer countsdatabaseslockingqueues
Several workers taking jobs from a table
Five workers poll a jobs table. With plain FOR UPDATE they wait on each other for the same job row. Which query lets each worker grab a different job?
SELECT id FROM jobs WHERE status = 'pending' ORDER BY id LIMIT 1 FOR UPDATE ???;
Discussion 0
Join free to post in the discussion.
Related questions
- Building SQL from user inputBackend Developer
- What atomicity guaranteesBackend Developer
- WHERE column = NULL finds nothingBackend Developer
- COUNT(*) versus COUNT(column)Backend Developer
- Column type for pricesBackend Developer
- Storing order times for two countriesBackend Developer
- Students and courses table designBackend Developer
- What a foreign key doesBackend Developer