hm, no, it works fine with int and varchar(40) -----Ursprüngliche Nachricht----- Von: "danchik" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Freitag, 27. Juni 2003 00:01 Betreff: Re: can you insert null?
> 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
