Re: ENUM NOT NULL without default value

2001-09-30 Thread Paul DuBois
At 2:43 AM +0100 10/1/01, Corin Hartland-Swann wrote: >Hi Monty, > >I've been experimenting with ENUM NOT NULL columns without a default >value. The documentation (section 6.5.3 again) states: > >"If no DEFAULT value is specified for a column, MySQL automatically >assigns one. If the column may ta

ENUM NOT NULL without default value

2001-09-30 Thread Corin Hartland-Swann
Hi Monty, I've been experimenting with ENUM NOT NULL columns without a default value. The documentation (section 6.5.3 again) states: "If no DEFAULT value is specified for a column, MySQL automatically assigns one. If the column may take NULL as a value, the default value is NULL. If the column