[thelist] mysql update setting a value to null

[Ben Phillips]

> > i've tried 'UPDATE EVENT SET enddate = NULL'
> >            'UPDATE EVENT SET enddate = 'NULL''
> >            'UPDATE EVENT SET enddate IS NULL'
> >
>
> I was able to the following in MySQL
>
> UPDATE EVENT
> SET enddate = NULL

so, i obviously hadn't tried it properly. thanks jay, and i apologise
for being such a plonker.

benji
inchima.com