use mysql as a queue

chucklarge · #1 (**permalink**) 10-08-04, 13:55

Hi,
I want to find the best method to use mysql as a queue. So what I would want to do with existing mysql functions, add entries to the table at the back(ok that already happens on insert) then I want to read the first item easily, not have to put all the entrees into an array and just read the first. then delete the first entry easily.

Any help is appreciated.

Thanks,
Chuck

snorp · #2 (**permalink**) 10-11-04, 05:55

If you have an AUTO_INCREMENT column, the last inserted row will have the highest id and the first inserted will have the lowest.

When you want to remove an element from the queue, do ("ai_col" = the name of the AUTO_INCREMENT column)

Code:

SELECT ... FROM tab WHERE id=MIN(ai_col);
DELETE FROM tab WHERE id=MIN(ai_col);

If there are many clients accessing the "queue" at the same time, use some locking mechanism to avoid race conditions and other weird stuff.

Internet Services

Web Development

Digital Marketing

Consumer Tech