* 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]
