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
gt;
> ----- 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 to N
T to get a value 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
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> DESCR
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 |