the given data type enum() contains errors mysql

Question

I was using the data type enum() but I got this error in mysql workbench

Did you try to define an ENUM column with no elements? You need at least one. — Bill Karwin
– Bill Karwin, Commented Aug 22, 2018 at 23:17
cuz I am doing this in the setting not coding. there are 2 ways to set up enum(),one is by coding eg: Status ENUM('Yes','No) NOT NULL. I am doing it in the second way by using the settings. is there a way I can do it in the settings ? — KEVINBOSS
– KEVINBOSS, Commented Aug 22, 2018 at 23:26
Can you edit your question to include the exact statement you're running? Also remember that text, not screenshots, is the best way to represent textual data. Images can't be searched, copy-pasted or run as code. — tadman
– tadman, Commented Aug 23, 2018 at 2:25

TOKSSS · Accepted Answer · 2019-06-17 17:32:00Z

6

Each value must be quoted between single quotes, and they must be separated with commas. For example:

ENUM('Value1','Value2','Value3')

answered Jun 17, 2019 at 17:32

TOKSSS

611 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1