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