[EMAIL PROTECTED] wrote:
There is a "primary key" which is not the main order to access rows.Please re-read my post as well as the very manual reference you later gave; the PRIMARY KEY _is_ the row number, if you have one. If you use auto_increment for your primary key, then ORDER BY {primary key} _is_ ordering by insert order. If you want your query to use any other order, you _must_ create a column for that purpose; the database subsystem has no way of knowing (nor should it bother to track) what order rows are inserted / stored in.
What I am emulating is a large memory space and the "primary key" is just
used not to duplicate rows.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
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
