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. __

auto sorting

2004-01-25 Thread 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. How can I insert a new row to the end of the table, and select record