14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→check if field value was not fulfilled: NULL, empty value
No edit summary |
|||
| Line 101: | Line 101: | ||
* MySQL SQL syntax: {{kbd | key = SELECT * FROM table WHERE column IS NOT NULL;}} | * MySQL SQL syntax: {{kbd | key = SELECT * FROM table WHERE column IS NOT NULL;}} | ||
== 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 | {{exclaim}} NOT include those data which its field value fulfilled with default value automatically | ||
| Line 131: | Line 131: | ||
* MySQL: {{kbd | key =<nowiki>SELECT * FROM table_name WHERE LENGTH(TRIM( column_name )) != 0;</nowiki>}} | * MySQL: {{kbd | key =<nowiki>SELECT * FROM table_name WHERE LENGTH(TRIM( column_name )) != 0;</nowiki>}} | ||
* MySQL: {{kbd | key =<nowiki>SELECT * FROM table_name WHERE column_name != '' AND column_name IS NOT NULL;</nowiki>}} | * MySQL: {{kbd | key =<nowiki>SELECT * FROM table_name WHERE column_name != '' AND column_name IS NOT NULL;</nowiki>}} | ||
== verify the format of field value == | == verify the format of field value == | ||