MySQL: Resultset Randomly listed

HI

I have a simple table in my database called 'avatars'

Code:

---

CREATE TABLE `avatars` (
  `avatar_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `avatar_image_name` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (`avatar_id`)
) ENGINE=MYISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1

---

Which has some data in it.

When I run a simple select query:

Code:

---

SELECT *
FROM  `avatars`
LIMIT 0 , 30

---

What order does it follow to show the resultset? As u can see from the attached screenshot that the autoincrement id column is not in serial order.

Please explain this.


Attachment 59613

Quote:

---

Originally Posted by cancer10

Please explain this.

---

it's really simple

without an ORDER BY clause, the database engine is allowed to return rows in whatever sequence it wishes

Quote:

---

Originally Posted by r937

it's really simple

without an ORDER BY clause, the database engine is allowed to return rows in whatever sequence it wishes

---

I know but what I want to know is that does it have any internal logic at all?

Quote:

---

Originally Posted by cancer10

... does it have any internal logic at all?

---

it returns them in the sequence it finds them

Quote:

---

Originally Posted by r937

it returns them in the sequence it finds them

---

But logically should not it find the records in the sequence it was inserted?

Thanks.

no, because the insertion takes place on the most readily available disc space, which could be anywhere in the sequence

Quote:

---

Originally Posted by r937

no, because the insertion takes place on the most readily available disc space, which could be anywhere in the sequence

---

Thats strage!!

Where did you find this info sir? coz I was unble to see any such info in the official document :(

Quote:

---

Originally Posted by cancer10

...I was unble to see any such info in the official document :(

---

you're gonna have an even harder time finding anything that contradicts it

:D