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.


Selection_001.png