MySQL Forums :: General :: ENUM columns and blank values


Advanced Search

ENUM columns and blank values
Posted by: Tom Byars ()
Date: March 05, 2009 04:07AM

You can't make one of the enum choices ''. You can't give an enum field a default value of ''. You can't UPDATE an enum field to ''. You can't UPDATE an enum field to have value 0. You can't give an enum field a default value of 0.

You can edit a table with an enum field in the query browser and set the enum field to 0 and that gives the field a value of ''.

Whoever's responsible for the design of enum fields missed his vocation in life. They should've been designing puzzle books.



Edited 1 time(s). Last edit at 03/05/2009 04:08AM by Tom Byars.

Options: ReplyQuote


Subject Written By Posted
ENUM columns and blank values Tom Byars 03/05/2009 04:07AM


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.