Hi Benjamin,
> > Isn't _rowid some type of internal variable? What is its exact
> purpose and
> > significance?
Thanks for nailing the matter down.
> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:39492:cnfpdcnkgalicmjgekef
"My main concern is that if we would make ROWID's available for the
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 this
is of type integer, one can also refer to it as _rowid"
Isn't _rowid some type of internal varia
> 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
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
Hi,
I need a 20 GB + DB that I'd like to access by row number or physical order.
Of course I could use a special rownum column but that would be a waste of
space plus require an additional key whereas mySQL already maintains such
table internaly.
Hope this makes sens,
Best,
Thierry
www.arbitr
