Hi Smith,
the fact that _rowid "may change over time depending on many factors"
doesn't concern MySQL,
but it is valable for mSQL.
Regards.
Thierno 6C - MySQL 4.0.15
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]&
* Guy Smith
> I'd like to use the _rowid capability of MySQL to improve the
> efficiency of a project, but I have concerns about the
> reliability of the number it returns. I understand that _rowid
> "may change over time depending on many factors," but I'd like t
I'd like to use the _rowid capability of MySQL to improve the efficiency of a project,
but I have concerns about the reliability of the number it returns. I understand that
_rowid "may change over time depending on many factors," but I'd like to know whether
this is true
Dean Harding wrote:
Like I said, the ROWID in Oracle is the *physical address* of the row.
It's made up of three parts: datafile, block and offset. If you say:
select * from some_table where rowid='RRRBBFFF';
In that case, I'm more confused about why anyone would want to specify
"ORDER
> >In Oracle, because the ROWID is the actual physical address of the
row,
> >it provides O(1) access to a row, as opposed to O(log(n)) that an
index
> >provides. That's a pretty good benefit if you ask me.
> >
>
> I'd love to see the math on that proven; I'm running it through my
head
> now and
developers, perhaps.
Sorry; I crossed DB admin with DB developper ... I happen to have both
titles. That said, I'd like to point out the error of your other
comment; (as I understand it, please correct me if I'm wrong) if MySQL
doesn't have any indexes on a table (your choice, a
gt;
> Neither does an auto_increment index value that you put in the table
> yourself. I'm still waiting to hear a proponent of _rowid tell me why
> _rowid is _better_ for _database_admins_ than using an auto_increment
> column value. The '_rowid takes no space' a
_increment index value that you put in the table
yourself. I'm still waiting to hear a proponent of _rowid tell me why
_rowid is _better_ for _database_admins_ than using an auto_increment
column value. The '_rowid takes no space' argument is hogwash; its
stored by Oracle in
ge-
From: [EMAIL PROTECTED] [mailto:horizonx@;noos.fr]
Sent: Thursday, 14 November 2002 9:52 pm
To: [EMAIL PROTECTED]
Subject: Re: _rowid
Hi Benjamin,
> > Isn't _rowid some type of internal variable? What is its exact
> purpose and
> > significance?
Thanks for nailing the matte
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 ma
this
> is of type integer, one can also refer to it as _rowid"
>
> Isn't _rowid some type of internal variable? What is its exact purpose and
> significance?
Well, as it has been implemented due to user request, searching the
archives may help:
http://lists.mysql.com/cgi-ez/ezm
[EMAIL PROTECTED] wrote:
"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 variable? Wh
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 t
13 matches
Mail list logo
