14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→duplicate data
m (→duplicate data) |
|||
| Line 189: | Line 189: | ||
* PHP: [http://php.net/manual/en/function.array-unique.php PHP: array_unique], [http://php.net/manual/en/function.array-intersect.php PHP: array_intersect] | * PHP: [http://php.net/manual/en/function.array-unique.php PHP: array_unique], [http://php.net/manual/en/function.array-intersect.php PHP: array_intersect] | ||
* MySQL: | * MySQL: | ||
** [http://www.mysqltutorial.org/mysql-distinct.aspx MySQL DISTINCT - Eliminate Duplicate Rows in a Result Set] | ** [http://www.mysqltutorial.org/mysql-distinct.aspx MySQL DISTINCT - Eliminate Duplicate Rows in a Result Set]. Using {{kbd | key =GROUP_CONCAT}} to handle the multiple columns<ref>[http://stackoverflow.com/questions/12188027/mysql-select-distinct-multiple-columns sql - MySQL SELECT DISTINCT multiple columns - Stack Overflow]</ref> | ||
** [http://www.w3schools.com/sql/sql_unique.asp SQL UNIQUE Constraint] | ** [http://www.w3schools.com/sql/sql_unique.asp SQL UNIQUE Constraint] | ||