[EMAIL PROTECTED] wrote:

"Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version
3.23.11: If the PRIMARY or UNIQUE key consists of only one column and this
is of type integer, one can also refer to it as _rowid"

Isn't _rowid some type of internal variable? What is its exact purpose and
significance?
In other words why did the designer of mySQL bother naming that specialized
column as such.

That has been explained to you already; _IF_ you have a primary key already (that's not internal, that's something _YOU_ create), _THEN_ _rowid exists as a pointer to that primary key, and _ONLY IF_ the primary key is one column and is an integer. Basically, _rowid is completely pointless except if you don't feel like remembering the name of the primary key column in your tables (which I always name 'ID').

Do you understand now? And _WHY_ do you care? What is wrong with using your own primary key (which _rowid _REQUIRES_ anyway)??

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Reply via email to