List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:November 6 2003 7:27pm
Subject:Re: ROWID
View as plain text  
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.

Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |

MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 2,006,935,277 queries (431/sec. avg)
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