Re: auto sorting

2004-01-25 Thread Stefan Kuhn
Am Sunday 25 January 2004 23:17 schrieb Lorderon: > Hello All, > > I got a table with a VARCHAR(255) field as a primary key, but when I insert > a new row it inserts it ordered by the key. Then, when I select rows > without doing any order, it returns the rows ordered by the primary key. That's by

re: auto sorting

2004-01-25 Thread Jeremy March
Why don't you want to use an ORDER BY? I think its the _only_ way to get a stable order. It sounds like you want to retrieve your rows in the order in which they were entered. If you don't want an auto_increment field you could order by a timestamp. __