Yes, that works for Teradata and Oracle as well. Regards, Jake Johnson [EMAIL PROTECTED]
------------------------------------------------------------------ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Thu, 26 Jun 2003 [EMAIL PROTECTED] wrote: > hm? i just did a little test on mysql 3.23.56-nt, and had no problems setting a null > value on a null column having a default value other than null. it turned to be null, > rather than the default value. > > ˇˇˇ yves at unclassified.de > > > -----Ursprüngliche Nachricht----- > Von: "danchik" <[EMAIL PROTECTED]> > An: <[EMAIL PROTECTED]> > Gesendet: Donnerstag, 26. Juni 2003 23:20 > Betreff: Re: can you insert null? > > > > your statement will do just that, but make sure the field has no default > > value and allows NULL > > > > ----- Original Message ----- > > From: "Bill2" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, June 26, 2003 1:48 PM > > Subject: can you insert null? > > > > > > > Hello all, > > > > > > Does anyone know if you can put the value(not the string) NULL? > > > > > > Something like > > > UPDATE TABLE some_table SET field = NULL > > > > > > > > > Thanks, > > > > > > Bill > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
