2 messages in com.mysql.lists.gui-toolsRe: Bug?: How to create "int" field w...
FromSent OnAttachments
Teemu Kuulasmaa11 Jul 2003 00:18 
Adam Majer15 Jul 2003 12:50 
Subject:Re: Bug?: How to create "int" field without default value
From:Adam Majer (ada@galacticasoftware.com)
Date:07/15/2003 12:50:54 PM
List:com.mysql.lists.gui-tools

On Fri, Jul 11, 2003 at 10:19:14AM +0300, Teemu Kuulasmaa wrote:

Hi,

In mysqlcc I am not able to create new "int" field without default value. Even if I check "Allow NULL" and remove "Default" value mysqlcc will ALWAYS set default value for culumn to "0".

Hi,

For a work arround just use SQL to add an INT field.

ALTER TABLE blah ADD field INTEGER;

or DECIMAL(x,y) or whatever. the default is then NULL.