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

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 TABLE

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 I

Changing Default for Not Null to NOTHING

2002-03-08 Thread Victoria Reznichenko
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

Re: Changing Default for Not Null to NOTHING

2002-03-08 Thread David M. Peak
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

Changing Default for Not Null to NOTHING

2002-03-07 Thread David M. Peak
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 |