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