Databases Reference
In-Depth Information
In the value list, we have to enclose each value within single quotes, unlike in the
default value field. Starting with version 3.4.0, an editor targeted for ENUM/SET
columns is available. With this editor, we don't need to bother enclosing values within
single quotes. Clicking on Get more editing space brings this editor into action:
In our design, these values stand for Fantasy , Child , and Novel . However, for now,
we want to see the interface's behavior with short code. In the Insert panel, we now
see a radio box interface as shown in the following screenshot:
If we decide to have more self-describing values, we can go back to Structure mode
and change the values definition for the genre column. We also have to change the
default value to one of the possible values, to avoid getting an error message while
trying to save this column structure's modification.
 
Search WWH ::




Custom Search