MySQL Forums
Forum List  »  Newbie

retrieve enum values
Posted by: Dacian Halmagean
Date: January 04, 2008 02:49AM

Hi,

There is a column of type enum ( 'A', 'B', 'C', 'D').
How can I get via a query all enum values available for column ?

Is there a better query than:
describe table column;

I would prefer a query which give responses like:
"A"
"B"
"C"
"D"


Thanks,
Dacian

Options: ReplyQuote


Subject
Written By
Posted
retrieve enum values
January 04, 2008 02:49AM
January 04, 2008 04:53AM
January 04, 2008 06:27AM
January 04, 2008 06:48PM
January 06, 2008 12:45PM
January 07, 2008 12:47AM


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.