When to use NULL as default value

Hi all, I pretty much set a fields default value to NULL if it not a required field in my app. Just wondering if this is the way to go since I just sort of guessed at this method ;) - Charles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Null to a value...

Hi again, I need to change cross 600 records that have 'Null' in the field and I need to change it a value. What is the sql statement that will let me change that field. Chuck Payne Magi Design and Support - Before posting,

RE: Null to a value...

: Sunday, September 08, 2002 2:35 PM To: [EMAIL PROTECTED] Subject: Null to a value... Hi again, I need to change cross 600 records that have 'Null' in the field and I need to change it a value. What is the sql statement that will let me change that field. Chuck Payne Magi Design and Support

ENUM NOT NULL without default value

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

Re: ENUM NOT NULL without default value

as a value, the default value is NULL. If the column is declared as NOT NULL, the default value depends on the column type ... for ENUM, the default is the first enumeration value. This is all fine (and seems like a reasonable assumption to make), but I discovered that using ALTER TABLE