Re: Understanding mysql NULL handling ...

2007-06-14 Thread ViSolve DB Team
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: == mysql show create table t1

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; +--- +---

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 SQL