Re: can you insert null?

[Paul DuBois]

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]