3 messages in com.mysql.lists.win32mysql defaults
FromSent OnAttachments
Daniel Canham08 Feb 2004 19:22 
Spock09 Feb 2004 08:40 
Friedhelm Betz09 Feb 2004 14:55 
Subject:mysql defaults
From:Daniel Canham (dcan@rochester.rr.com)
Date:02/08/2004 07:22:28 PM
List:com.mysql.lists.win32

Hi Everyone,

Ok...I'm a little confused as to how table defaults work. Ex:

<table> column1 <varchar> default '' column2 <double> default 0 column3 <double> default 0 column4 <double> default 0 column5 <double> default 0 column6 <double> default 0

INSERT <table> SET column1 = 'Hello World';

...The column 1 value gets set fine, but all the other columns get the annoying -6.27743856220419e+066 whatever number as the value. Why wouldn't the default values kick in at this point? What am I doing wrong??

-Dan