set column default

[jenniferG]

we have a table  sistock with column cameramodel  varchar(30) and try to  set default value to blank with the following:

 

ALTER TABLE SISTOCK CHANGE COLUMN CAMERAMODEL CAMERAMODEL ENUM ('INSTOCK',

'BACKORDER','SERVICE','OBSOLETE') DEFAULT '';

 

and we get an error at the mysql prompt;

Thanks,

Jennifer

[MadTechie]

try

ALTER TABLE SISTOCK CHANGE COLUMN CAMERAMODEL CAMERAMODEL ENUM ('', 'INSTOCK',
'BACKORDER','SERVICE','OBSOLETE') NOT NULL;

 

If an ENUM column is declared to allow NULL, the NULL value is a legal value for the column, and the default value is NULL. If an ENUM  column is declared NOT NULL, its default value is the first element of the list of allowed values.