- Vertabelo
-
Questions
0
Answered
how to create ENUM in mysql
How can I create enumerated type.
For simplicity sake, say Male and Female
many thanks
Mark
For simplicity sake, say Male and Female
many thanks
Mark
Answer
Answer
Answered
Just insert your desired type into "Type" input. The selector (layer) with types contains only the most common datatypes. You can change it to whatever type you want. It looks like this:
This will rise a validation error saying that the type is not supported. This is our bug (not a critical one, I think). You can turn this validation off in "Model validation settings" which you can find in the menu on the top left, just below the Vertabelo logo. This validation rule is called "Supported database type (warnings)" in "Table column" section.
This will rise a validation error saying that the type is not supported. This is our bug (not a critical one, I think). You can turn this validation off in "Model validation settings" which you can find in the menu on the top left, just below the Vertabelo logo. This validation rule is called "Supported database type (warnings)" in "Table column" section.
The "N" allows you to make the column nullable. By default, columns have "NOT NULL" constraint (since it's a good practice) and you can change it with this checkbox.
Seems to me a bit fundamental that Vetabelo cannot handle all the data types supported by the chosen database. Turning "Supported database type (warnings)" off is not really a solution since that would then stop any real errors being flagged.
When will this bug be quashed?
When will this bug be quashed?
Actually, it's not just fixing the bug that erroneously flags an ENUM field as not supported by MySQL, but rather that Vertabelo needs to actively support their use. IOW provide a suitable area to enter the options rather than having to stuff them in the column name field.
Same goes for SET data type.
Same goes for SET data type.
+1
Support for ENUM and SET is on the way. It should be available in the coming weeks.
Customer support service by UserEcho
This will rise a validation error saying that the type is not supported. This is our bug (not a critical one, I think). You can turn this validation off in "Model validation settings" which you can find in the menu on the top left, just below the Vertabelo logo. This validation rule is called "Supported database type (warnings)" in "Table column" section.