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]