[EMAIL PROTECTED] wrote:
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.
Please re-read my post as well as the very manual reference you later
gave; the PRIMARY KEY _i
> There is no row number in MySQL. You should use ORDER BY to
>> retrieve data in particular order.
handf> What about the following info in the manual p. 55?
handf> Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version
handf> 3.23.11: If the PRIMARY or UNIQUE key consists of o
> There is no row number in MySQL. You should use ORDER BY to
> retrieve data in particular order.
What about the following info in the manual p. 55?
Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version
3.23.11: If the PRIMARY or UNIQUE key consists of only one column and thi
I need a 20 GB + DB that I'd like to access by row number or physical order.
handf> Of course I could use a special rownum column but that would be a waste of
handf> space plus require an additional key whereas mySQL already maintains such
handf> table internaly.
There is no row number in MySQL.
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 strai
>From: <[EMAIL PROTECTED]>
>
>I need a 20 GB + DB that I'd like to access by row number or physical order.
Are you certain?
In my experience, people who claim they need to access by physical order are making a
bunch of faulty assumptions, and REALLY want to access by temporal order, which is not
