MySQL Forums
Forum List  »  PHP

SQL Select behavior on table with no index
Posted by: kart bart
Date: January 06, 2006 11:17AM

I have a table - lets call it TEST.
It has 1 column:
page_ID integer.

I need to have different application connections try and grab the first entry. They then delete the entry after selecting it. I'm using the following query:

SELECT * FROM test LIMIT 1 FOR UPDATE

Is this guaranteed to fetch the rows in the order in which they were entered into the TEST table or can the order get disrupted? Also, is there any query which will make the next connection not block on the first row but go to the next row instead?

Options: ReplyQuote


Subject
Written By
Posted
SQL Select behavior on table with no index
January 06, 2006 11:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.