U could always use a PRIMARY key on an auto_increment column. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688
-->-----Original Message----- -->From: Mike Brando [mailto:[EMAIL PROTECTED] -->Sent: Thursday, November 06, 2003 1:03 PM -->To: [EMAIL PROTECTED] -->Subject: RE: ROWID --> --> -->> -----Original Message----- -->> 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 --> -->--------------------------------------------------------------------- - -->Michael Brando -->Senior Manager of Engineering -->Applied Biosystems -->3833 North First Street -->San Jose, CA 95134-1701 --> --> -->-- -->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]