14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→by datatype
| Line 69: | Line 69: | ||
=== by datatype === | === by datatype === | ||
==== VARCHAR and allows NULL value ==== | |||
<table border="1" style="width: 100%"> | <table border="1" style="width: 100%"> | ||
<tr style="background-color: #555555; color: #ffffff;"> | <tr style="background-color: #555555; color: #ffffff;"> | ||
| Line 123: | Line 124: | ||
* method4: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE column_name IS NOT NULL</nowiki>}} | * method4: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE column_name IS NOT NULL</nowiki>}} | ||
==== VARCHAR or numeric ==== | |||
<table border="1" style="width: 100%"> | <table border="1" style="width: 100%"> | ||
<tr style="background-color: #555555; color: #ffffff;"> | <tr style="background-color: #555555; color: #ffffff;"> | ||
| Line 156: | Line 157: | ||
* method5: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE column_name BETWEEN min AND max</nowiki>}} | * method5: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE column_name BETWEEN min AND max</nowiki>}} | ||
* method6: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE ( (COALESCE(column_name, '') = '') OR (column_name NOT BETWEEN min AND max) )</nowiki>}} | * method6: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE ( (COALESCE(column_name, '') = '') OR (column_name NOT BETWEEN min AND max) )</nowiki>}} | ||
==== datetime and allows NULL value ==== | |||
possible column values | |||
# {{kbd | key = {{Template:Today}}}} | |||
# {{kbd | key = 00-00-00 00:00:00}} | |||
# {{kbd | key = NULL}} | |||
=== is null === | === is null === | ||