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
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,
Friday, March 08, 2002, 11:03:30 PM, you wrote:
DMP I
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 TABLE
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
I
David,
Thursday, March 07, 2002, 7:22:49 PM, you wrote:
DMP Is there a way for me to NOT have a default value for a column in a table
DMP that I define as NOT NULL?
DMP EXAMPLE SQL:
DMP mysql CREATE TABLE FOO (foo1 int NOT NULL);
DMP Query OK, 0 rows affected (0.05 sec)
DMP mysql DESCRIBE
if it is left out of an
insert statements list of column/value set.
Does this make sense??
- Original Message -
From: David M. Peak [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Thursday, March 07, 2002 9:22 AM
Subject: Changing Default for Not Null to NOTHING
Is there a way for me
Is there a way for me to NOT have a default value for a column in a table
that I define as NOT NULL?
EXAMPLE SQL:
mysql CREATE TABLE FOO (foo1 int NOT NULL);
Query OK, 0 rows affected (0.05 sec)
mysql DESCRIBE FOO;
+---+-+--+-+-+---+
| Field | Type| Null |