MySQL Forums
Forum List  »  Newbie

Re: Are pseudo columns supported in MySql
Posted by: Rick James
Date: June 11, 2009 11:26PM

There are no accessible hidden fields.

In InnoDB, if you don't provide a PRIMARY KEY (and...), a hidden BIGINT will be used as the PK. But you cannot get at it.

In MyISAM, each row in each index has a byte/row offset into the data file (.MYD). But you cannot get at it.

There is information about the table; this is found either via
SHOW TABLE STATUS
or by rummaging through the pseudo database
information_schema.

Options: ReplyQuote


Subject
Written By
Posted
Re: Are pseudo columns supported in MySql
June 11, 2009 11:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.