Thread: inserting a value as null

inserting a value as null

From

"Zouari Fourat"

Date:

20 February 2006, 09:31:01

How can i insert or update a value as NULL ?

Re: inserting a value as null

From

Oliver Elphick

Date:

20 February 2006, 09:56:33

On Mon, 2006-02-20 at 11:31 +0100, Zouari Fourat wrote:
> How can i insert or update a value as NULL ?

Use the keyword NULL instead of a constant or variable.

For example:

  UPDATE mytable SET mycol = NULL;

--
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html