14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→is null
| Line 91: | Line 91: | ||
=== is null === | === is null === | ||
Fill 0 if the value is NA or NULL | {{Gd}} Fill 0 if the value is NA or NULL | ||
* MySQL SQL syntax: {{kbd | key = SELECT COALESCE(column_name, 0) }} | * MySQL SQL syntax: {{kbd | key = SELECT COALESCE(column_name, 0) }} | ||
** (1) Using [http://www.w3resource.com/mysql/comparision-functions-and-operators/coalesce-function.php COALESCE() function] to replace the NULL value with 0. | ** (1) Using [http://www.w3resource.com/mysql/comparision-functions-and-operators/coalesce-function.php COALESCE() function] to replace the NULL value with 0. | ||