Re: Understanding mysql NULL handling ...

2007-06-13 Thread ViSolve DB Team
ent: Thursday, June 14, 2007 1:20 AM Subject: Understanding mysql NULL handling ... Hello, I am using Ver 8.41 Distrib 5.0.27, for apple-darwin8.5.1 on i686 == My table definition: ===

Re: Understanding mysql NULL handling ...

2007-06-13 Thread Jon Ribbens
On Wed, Jun 13, 2007 at 12:50:03PM -0700, Mufaddal Khumri wrote: > mysql> select * from t1 where sid != 2; > > As you can see, the rows that had sid = NULL did not get returned in > the results when i did "... where sid != ; " > > Question: Is this behaviour correct and is in accordance to the

Understanding mysql NULL handling ...

2007-06-13 Thread Mufaddal Khumri
Hello, I am using Ver 8.41 Distrib 5.0.27, for apple-darwin8.5.1 on i686 == My table definition: == mysql> show create table t1; +--- +--- --