Go Back   Forum Care Forums > Development Reference Area > MySQL Discussion

Reply
 
LinkBack Thread Tools Display Modes
Treat Table like a queue
Old
  (#1)
Melih Onvural
Guest
 
Posts: n/a
Default Treat Table like a queue - 06-04-2007, 07:58 AM

Hello All,

I don't know if this is possible or if I'm just imagining
functionality, but is there not a way to select and delete in the same
statement and use a table as a queue with this Select/Delete
functionality acting like a pop() command. Thanks in advance,

--Melih Onvural

   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Re: Treat Table like a queue
Old
  (#2)
Dikkie Dik
Guest
 
Posts: n/a
Default Re: Treat Table like a queue - 06-04-2007, 07:58 AM

> I don't know if this is possible or if I'm just imagining
> functionality, but is there not a way to select and delete in the same
> statement and use a table as a queue with this Select/Delete
> functionality acting like a pop() command. Thanks in advance,



Sure there is. Just write a stored procedure for that. Your MySQL
version has to support it, though.

Best regards.
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Contact Us - Forum Care Forums - Archive - Top