I take that back about defaults, worked fine on all types... the earlier test i did on varchar after inserting NULL i brought the field up in edit mode and aparently the editor converted it to literal "(NULL)" from NULL (maybe it thought to be smart with varchars) where as the actual stored value was NULL
----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "danchik" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 26, 2003 2:31 PM Subject: Re: can you insert null? > At 14:20 -0700 6/26/03, danchik wrote: > >your statement will do just that, but make sure the field has no default > >value and allows NULL > > Why would it matter if it has a default value? > > > > > >----- 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 > > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > > > -- > 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]
