Re: CREATE TABLE and specifying DEFAULT

2005-06-15 Thread Danny Stolle
Les Schaffer wrote: Gordon Bruce wrote: I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows upgrading to 5.0.6 solved the problem. do i need to let MySQL developers know about this or do they monitor the list or once a release is gone, i can assume THIS problem was fixed? th

Re: CREATE TABLE and specifying DEFAULT

2005-06-13 Thread Les Schaffer
Gordon Bruce wrote: I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows upgrading to 5.0.6 solved the problem. do i need to let MySQL developers know about this or do they monitor the list or once a release is gone, i can assume THIS problem was fixed? thanks to all for the f

Re: CREATE TABLE and specifying DEFAULT

2005-06-13 Thread Danny Stolle
Les Schaffer wrote: Gordon Bruce wrote: I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows i was running 5.0.4 on Windows: mysql> \s -- mysql Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32) switching to 5.0.6 now. anyone wanna make a bet ;-) les schaffer eu

Re: CREATE TABLE and specifying DEFAULT

2005-06-13 Thread Danny Stolle
Les Schaffer wrote: Gordon Bruce wrote: I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows i was running 5.0.4 on Windows: mysql> \s -- mysql Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32) switching to 5.0.6 now. anyone wanna make a bet ;-) les schaffer eu

Re: CREATE TABLE and specifying DEFAULT

2005-06-13 Thread Les Schaffer
Gordon Bruce wrote: I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows i was running 5.0.4 on Windows: mysql> \s -- mysql Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32) switching to 5.0.6 now. anyone wanna make a bet ;-) les schaffer -- MySQL General Mailing

RE: CREATE TABLE and specifying DEFAULT

2005-06-13 Thread Gordon Bruce
#x27;, `ID_appt_hosp` char(10) default '-9', `ID_streetname_hosp` char(75) default '-9', `ID_streettype_hosp` char(6) default '-9', `ID_streettype_spec_hosp` char(25) default NULL, `ID_direction_hosp` char(2) default '-9', `ID_city_hosp` char(50) default '-

CREATE TABLE and specifying DEFAULT

2005-06-13 Thread Les Schaffer
i am trying to create a table as follows: CREATE TABLE ID ( mat INT PRIMARY KEY UNIQUE, ID_firstname CHAR(35), ID_lastname CHAR(35), ID_ramqnb CHAR(12), ID_numciv_hosp CHAR(10) DEFAULT '-9', ID_appt_hosp CHAR(10) DEFAULT '-9', ID_streetname_hosp CHAR(75) DEFAULT '-9', ID_streettype_hosp CHAR(6) D