Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→by datatype
| Line 73: | Line 73: | ||
</table> | </table> | ||
=== | === By datatype === | ||
==== VARCHAR and NOT allows NULL value ==== | ==== VARCHAR and NOT allows NULL value ==== | ||
Using NULLIF() function<ref>[https://www.w3schools.com/sql/func_mysql_nullif.asp MySQL NULLIF() Function]</ref> | Using NULLIF() function<ref>[https://www.w3schools.com/sql/func_mysql_nullif.asp MySQL NULLIF() Function]</ref> | ||