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]
