Edd,
mySQL, like any other RDBMS, does (and can not) not insert data in a
guaranteed order into a table. While mySQL might usually insert the most
recent record "last" in a table, you should never rely upon the fact.
Refusing to sort your data on the basis of system load sounds a little
strange - you're missing out on 99% of the functionality of a database
server if the only thing you do with are are simple unordered
non-joined inserts and selects. Perhaps you should just be using Notepad
or Pico to edit your webpage by hand ?
regards,
Peter
On Mon, 26 Feb 2001, TEXLID_SUPPORT wrote:
> Hello,
>
> I have a table which keeps a list of of clients. When a new client is to be added to
>the list I want it to be added to the first row of the table so that I will have a
>list of clients with the most recent arrival at the top and the least recent at the
>bottom of the table. I know I can do this by sorting the records by timestamp.
>However sorting always costs time.
>
> Is there a way of inserting new entries into a mysql table as a first entry at the
>top. Normally mysql adds them to the bottom of the table.
>
> I want to do this because I want the most recent entry to appear at the top of the
>list of a dynamically generated web page.
>
>
> Much obliged for any help on this issue.
>
> Edd.
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
