There is a "primary key" which is not the main order to access rows.
What I am emulating is a large memory space and the "primary key" is just used not to duplicate rows. In the current DB I use, I simply use the row number as my "memory pointer". Since rows are fixed length, it should be a straightforward matter to point to the right one and not require a rowid and key. mySQL must have an internal mean of referencing rows and that is what I'd like to use. I know there are limitations to the approach such as not issuing an ALTER ... ORDER BY ... but that won't be more necessary than changing an address on a memory stick ... > > > On Thu, 2002-10-31 at 18:15, [EMAIL PROTECTED] wrote: > > I need a 20 GB + DB that I'd like to access by row number or > physical order. > > > > SELECT ... ORDER BY PrimaryKey. > > You do have a primary key in the table, right? > -- > Michael T. Babcock > CTO, FibreSpeed Ltd. > --------------------------------------------------------------------- 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