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?

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)

RE: CREATE TABLE and specifying DEFAULT

2005-06-13 Thread Gordon Bruce
| +---+--- - - 1 row in set (0.00 sec) -Original Message- From: Les Schaffer [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 2:27 PM To: mysql@lists.mysql.com Subject: CREATE TABLE and specifying DEFAULT i am trying

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 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

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

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