was the field type varchar? because it seems that no default varchars set the NULL or (NULL) as a literal "(NULL)" not a binary 0 for some reason.
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "danchik" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 26, 2003 2:31 PM Subject: Re: can you insert null? 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]
