Re: Changing Default for Not Null to NOTHING

2002-03-15 Thread Egor Egorov
David, Thursday, March 14, 2002, 9:30:24 PM, you wrote: DMP> ok, more specific: DMP> here is a table: DMP> CREATE TABLE FOO (foo1 int NOT NULL, foo2 int NOT NULL Default 1) DMP> If I do an insert into the FOO table with the following: DMP> INSERT INTO FOO (foo1,foo2) VALUES (1,1) DMP> Everything

Re: Changing Default for Not Null to NOTHING

2002-03-14 Thread David M. Peak
ue in an insert statement Does this make more sense? Thanks, David - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 6:54 AM Subject: Re: Changing Default for Not Null to NOTHING > David, > Fri

Re: Changing Default for Not Null to NOTHING

2002-03-13 Thread Egor Egorov
David, Friday, March 08, 2002, 11:03:30 PM, you wrote: DMP> I just tried something and would a second opinion: DMP> I re-configured my MySQL server on my RH Linux machine using the following : DMP> CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure DMP> and ran the following SQL: DMP> CREATE TABL

Re: Changing Default for Not Null to NOTHING

2002-03-12 Thread David M. Peak
Beings as I haven't gotten an answer to this, is there a better place to find information on this? - Original Message - From: "David M. Peak" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Friday, March 08, 2002 1:03 PM Subject:

Re: Changing Default for Not Null to NOTHING

2002-03-08 Thread David M. Peak
I just tried something and would a second opinion: I re-configured my MySQL server on my RH Linux machine using the following : CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure and ran the following SQL: CREATE TABLE FOO (foo int NOT NULL DEFAULT 5, foo1 INT NULL); INSERT INTO FOO (foo1) VALUES