14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→check if field value was not fulfilled: NULL, empty value
No edit summary |
|||
| Line 13: | Line 13: | ||
== check if field value was not fulfilled: NULL, empty value == | == check if field value was not fulfilled: NULL, empty value == | ||
{{exclaim}} NOT include those data which its field value fulfilled with default value automatically | |||
([http://sqlfiddle.com/#!2/9b01e/3/0 demo on sqlfiddle]) | ([http://sqlfiddle.com/#!2/9b01e/3/0 demo on sqlfiddle]) | ||
# {{kbd | key = NULL}} value: {{kbd | key = SELECT * FROM table_name WHERE column_name IS NULL;}} | # {{kbd | key = NULL}} value: {{kbd | key = SELECT * FROM table_name WHERE column_name IS NULL;}} | ||