'%TYPE' equivalent

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- - 28 Jan 2005 04:31 GMT

my apologies for asking this qn in here as my post at the mysql didn't
get a reply.

in oracle there is a '%TYPE' to reference the data type of another
column. is there an equivalent in mysql? thank you.

Reply to this Message

DA Morgan - 28 Jan 2005 07:55 GMT

> my apologies for asking this qn in here as my post at the mysql didn't
> get a reply.
>
> in oracle there is a '%TYPE' to reference the data type of another
> column. is there an equivalent in mysql? thank you.

I don't believe there is in MySQL or any of the other commercial
RDBMS's. And it is not to reference "another column" but rather to
define a variable's data type and scale and precision based on a
table and column. No equivalent to %ROWTYPE either TTBOMK.

I hope to be corrected if this is not the case any longer.

Signature

Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

Reply to this Message