List:General Discussion« Previous MessageNext Message »
From:Dathan Vance Pattishall Date:November 6 2003 9:09pm
Subject:RE: ROWID
View as plain text  
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:mbrando@stripped]
-->Sent: Thursday, November 06, 2003 1:03 PM
-->To: mysql@stripped
-->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/mysql?unsub=1



Thread
ROWIDWenhua Wan6 Nov
  • Re: ROWIDJeremy Zawodny6 Nov
    • RE: ROWIDMike Brando6 Nov
      • RE: ROWIDDathan Vance Pattishall6 Nov
      • Re: ROWIDChris Boget6 Nov
      • RE: ROWIDDaniel Kiss6 Nov
      • Re: ROWIDJeremy Zawodny8 Nov
        • Re: ROWIDDan Nelson8 Nov
    • Re: ROWIDPatrick Sherrill8 Nov