ENUM issue!!!

[Zaria]

Hi !
there is a table where one column named test which is ENUM-type.
ENUM choices are: Yes, No.
Now When I add on record:
INSERT INTO table set test="Maybe";
and when I look the result there are one record:
test
----
NULL
I wana make column where the user cant add anything else than Yes or NO.
I dont want to have NULL values or empty-values. Is this possible? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[ishac]

You need to alter the table like add the Maybe value to the ENUM:

ALTER TABLE tablename MODIFY COLUMN columnname ENUM('Yes','No','Maybe');
Then change NULLs to Maybes:

UPDATE tablename SET columnname='Maybe' WHERE columnname IS NULL;
And finally disallow NULLs in the column:

ALTER TABLE tablename MODIFY COLUMN columnname ENUM('Yes','No','Maybe') NOT NULL DEFAULT 'Maybe'; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --