Re: default, Nullable and NULL : confused

2008-07-16 Thread Ananda Kumar
in your data file use this for inserting null values '\N' 0.12345;qwer 1.2345;\N \N;asdf On 7/17/08, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote: > > Hello, > > I do not understand the behavior of a simple table : > from what I red, in the following exemple the Null column tells the value > can

default, Nullable and NULL : confused

2008-07-16 Thread Gilles MISSONNIER
Hello, I do not understand the behavior of a simple table : from what I red, in the following exemple the Null column tells the value can be set to NULL, and the Default value is NULL. It doesn't seem to work that way. Some one could explain it ? I run on a linux debian/etch 5.0.32 MySQL relea