You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Bob M <rg...@orcon.net.nz> on 2016/02/07 02:55:19 UTC

changing a field contents to

Hi

I am using Netbeans to view and correct some data I have in an Apache Derby
Database

I need to delete the contents of the odd field and replace it with <NULL>

How do I enter the <NULL> part?

Bob M



--
View this message in context: http://apache-database.10148.n7.nabble.com/changing-a-field-contents-to-NULL-tp145533.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: changing a field contents to

Posted by John English <jo...@gmail.com>.

On 07/02/2016 03:55, Bob M wrote:
> I need to delete the contents of the odd field and replace it with <NULL>
>
> How do I enter the <NULL> part?

UPDATE blah SET blah=NULL WHERE blah.

Exactly the same as updating to a non-null value.
-- 
John English