MySQL Forums
Forum List  »  Newbie

How are rows ordered when no order by clause is added to the select?
Posted by: hagai yaffe
Date: May 26, 2005 02:25AM

Hello,

This might be a simple question but I could not find an answer in the documentation.

I have created a table:

CREATE TABLE test (

UserName VARCHAR(29) NOT NULL,
UserId bigint NOT NULL auto_increment,

PRIMARY KEY (‘UserId’)
);

I insert rows into this table and then I perform select * from the table. Can I be sure that I will get the rows ordered by UserId column or must I add an OREDR BY clause to the select? This might be obvious be is it important to me and I need to be sure.

If someone could verify / refute me assumption it would help me allot.

TX.

Hagai.

Options: ReplyQuote


Subject
Written By
Posted
How are rows ordered when no order by clause is added to the select?
May 26, 2005 02:25AM


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.