Data cleaning: Difference between revisions

Jump to navigation Jump to search
107 bytes added ,  8 January 2014
m
No edit summary
Line 8: Line 8:
* MySQL {{kbd | key = SELECT * FROM table WHERE column IS NULL;}}<ref>[http://dev.mysql.com/doc/refman/5.0/en/working-with-null.html MySQL :: MySQL 5.0 Reference Manual :: 3.3.4.6 Working with NULL Values]</ref>
* MySQL {{kbd | key = SELECT * FROM table WHERE column IS NULL;}}<ref>[http://dev.mysql.com/doc/refman/5.0/en/working-with-null.html MySQL :: MySQL 5.0 Reference Manual :: 3.3.4.6 Working with NULL Values]</ref>


Finds whether a variable is NOT NULL
* MySQL {{kbd | key = SELECT * FROM table WHERE column IS NOT NULL;}}


== references ==
== references ==

Navigation menu