MySQL Forums
Forum List  »  Newbie

Re: retrieve enum values
Posted by: liu yingjiang
Date: January 04, 2008 06:48PM

because enum has just one value stored,so you just can query the value stored in the database.

if you want all values the enum field defined,use this:
desc tablename
show columns from tablename
explain tablename
they are all the same

this can tell you something:
show columns from tablename like 'type'

Edited 2 time(s). Last edit at 01/04/2008 06:55PM by liu yingjiang.

Options: ReplyQuote

Written By
January 04, 2008 02:49AM
January 04, 2008 04:53AM
January 04, 2008 06:27AM
Re: retrieve enum values
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.