Setting only a few values ​​as a domain to list in phpmyadmin

Question

How to set enum values ​​in phpmyadmin..I want to set the values ​​'0' or '1' in phpmyadmin for my field using the type "enum".

Answer 1

or under your phpmyadmin

• select enum

• in the Length/Values column: '0' ,'1'

and your done

Answer 2

 ALTER TABLE `table_name` CHANGE `old_column_name` `new_column_name` ENUM('0','1') DEFAULT NULL 

Answer 3

 CREATE TABLE tableName ( enumColumn ENUM('0','1') ); 

• SQLFiddle Demo
• MySQL ENUM Data Type

Answer 4

Long enough for this answer, maybe you should not use the one who asks this question, but may be useful for those who are not familiar with phpmyadmin. To set the default value for Enum, I will give the following example. Type = ENUM, Length / Values just enter a value inside one quotation mark, for example, "Male", "Woman", then select "Defined" by default : in the box below, simply enter Male without a quote. Hope this help!

Answer 5

Put the length / values ​​as for 0 and 1 '0', '1'

Answer 6

use the phpmyadmin => GUI by selecting the ENUM type and then just set the values.