No. There is no physical address of a row in MySQL.
>> On Thu, Nov 06, 2003 at 09:59:41AM -0800, Wan, Wenhua wrote: > >> Hi there, > >> > Both Oracle and Informix use ROWID to uniquely represent the >> location of > each row of data in a table. ROWID is basically a >> hidden column or > pseudocolumn for each table, and it is the >> fastest way to retrive a row from >> > a table. Does MySql have similar field? If is, what's the >> name and how to > access it? > > Thank you very much in >> advance for your advice. >> http://www.mysql.com/doc/search.php?q=rowid > > > Ok, so that search produces this: > > > " If the PRIMARY or UNIQUE key consists of only one column and this > is of type integer, you can also refer to it as _rowid (new in > Version 3.23.11)." > > But that's not what a "ROWID" is compared to what I think the > original poster was looking for. In Oracle for example, a ROWID is > the unique address of a row in the database. Every row, unique key > or not has a unique address. Is there such a thing in MySQL? ROWIDs > are extremely useful for guaranteeing that you are manipulating the > exact row that you think you are. > > Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
