[snip]
...will say if a field is of type ENUM, but not its possible values
(including default). Does anyone know how I can fetch possible values
of a field type of ENUM?
[/snip]
You would have to use DESCRIBE. So if
DESCRIBE db; //in the mysql table
returns --
Jay Blanchard wrote:
[snip]
...will say if a field is of type ENUM, but not its possible values
(including default). Does anyone know how I can fetch possible values
of a field type of ENUM?
[/snip]
You would have to use DESCRIBE. So if
Even better is
DESC table_name column_name;
so you only
2 matches
Mail list logo