13,468
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→check if field value was not fulfilled: NULL, empty value
| Line 17: | Line 17: | ||
# {{kbd | key = NULL}} value: | # {{kbd | key = NULL}} value: | ||
#* solution: {{kbd | key = SELECT * FROM table_name WHERE column_name IS NULL;}} | #* solution: {{kbd | key = SELECT * FROM table_name WHERE column_name IS NULL;}} | ||
#* EXCEL: {{kbd | key =<nowiki>=EXACT(A2, "NULL")</nowiki>}} | |||
# empty value: | # empty value: | ||
#* solution1: {{kbd | key = SELECT * FROM table_name WHERE LENGTH(TRIM( column_name )) = 0;}} | #* solution1: {{kbd | key = SELECT * FROM table_name WHERE LENGTH(TRIM( column_name )) = 0;}} | ||