Re: ROWID

2003-11-08 Thread Patrick Sherrill
Coral, FL 33904 (239) 540-2626 Voice - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Mike Brando" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, November 07, 2003 8:49 PM Subject: Re: ROWID > On

Re: ROWID

2003-11-08 Thread Dan Nelson
In the last episode (Nov 07), Jeremy Zawodny said: > > 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? > > No. If there was it'd be documented. But at least with MyISAM > tab

Re: ROWID

2003-11-07 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 01:02:31PM -0800, Mike Brando wrote: > > > -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. RO

RE: ROWID

2003-11-06 Thread Daniel Kiss
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  > pse

Re: ROWID

2003-11-06 Thread Chris Boget
> 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 gu

RE: ROWID

2003-11-06 Thread Dathan Vance Pattishall
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 unique

RE: ROWID

2003-11-06 Thread Mike Brando
> -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

Re: ROWID

2003-11-06 Thread Jeremy Zawodny
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

re: rowid

2003-02-27 Thread Egor Egorov
On Thursday 27 February 2003 06:54, geeta varu wrote: > i would like to use rowid in my query does > mySQL support this ..if s how do i give in query > please help... >From the MySQL manual: "If the PRIMARY or UNIQUE key consists of only one column and this is of type integer, you can al

RE: rowid

2003-02-27 Thread John Griffin
MySQL supports _rowid. _rowid is defined as a synonym for the primary key if the primary key consists of one column and is an integer. Hope this helps, John Griffin -Original Message- From: geeta varu [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 11:54 PM To: [EMAIL PROTE