Bluehost.com Web Hosting $6.95

Treat Table like a queue

This is a discussion on Treat Table like a queue within the MySQL Database forums, part of the Database Forums category; Hello All, I don't know if this is possible or if I'm just imagining functionality, but is there ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-17-2007
Melih Onvural
 
Posts: n/a
Default Treat Table like a queue

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

Reply With Quote
  #2 (permalink)  
Old 05-18-2007
Dikkie Dik
 
Posts: n/a
Default Re: Treat Table like a queue

> 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.
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 09:15 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0