List:General Discussion« Previous MessageNext Message »
From:Vlatko Surlan Date:September 12 2002 5:05pm
Subject:Re: Vaibhav Difference between amount <> null and amount is not null
View as plain text  
http://www.mysql.com/documentation/mysql/full/manual_toc.html#Working_with_NULL

On 12 Sep 2002, compo  guy wrote:

>   What is the difference between the following sql queries written 
> to
> >extract tuples with the field amount having non null value:
> >      select loan_number from loan where amount <> null (It 
> >returns
> >an empty set)
> >      select loan_number from loan where amount is not null(It
> >returns the expected result).
> >
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread119402@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-vsurlan=student.math.hr@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

Thread
Vaibhav Difference between amount <> null and amount is not nullcompo  guy12 Sep
  • Re: Vaibhav Difference between amount <> null and amount is not nullVlatko Surlan12 Sep
  • Re: Vaibhav Difference between amount <> null and amount is not nullDan Nelson12 Sep