Tuesday, February 16, 2010

Programmer - MySQL set NULL Query not always works

Programmer Question

UPDATE `table` 
SET `sent`='1', `taken`='1', `free`=NULL
WHERE `owner`='1' AND ISNULL(`sent`) AND !ISNULL(`free`);


Works, but set free to NULL works not always.
Any ideas? Thx

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails