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]> Cc: "Guy Smith" <[EMAIL PROTECTED]> Sent: Monday, October 20, 2003 11:48 PM Subject: Re: Reliability of _rowid over multiple database accesses > * 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 to > > know whether this is true if the row is locked. In particular, > > can I perform a select on a row which returns a _rowid, modify > > the row data, and later do an UPDATE using the _rowid as index, > > without worrying that the _rowid has changed? Any help will be > > much appreciated. > > The _rowid in MySQL is an alias for any field of a table with an unique > integer index, for instance a primary key. It is usefull when you don't > remember the name of the key, but it will not "improve efficiency" in any > other way, AFAIK. > > The value of a key will not change "over time", unless you explicitly change > it. > > There should be nothing to worry about. :) > > -- > Roger > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]