jcisio

# Colors
NoColor="\033[0m"
Cyan="\033[0;36m"
Green="\033[0;32m"
Red="\033[0;31m" 
Yellow="\033[0;33m"

# Chars
RootPrompt="\#"
NonRootPrompt="\$"

jcisio

<?php
/**
 * @file
 * Move taxonomy term from taxonomy_node table to field tables.
 */

$types = array(
  array(
    'type' => 'product',
    'fields' => array(

jcisio

-- Deduplication on all rows
CREATE TEMPORARY TABLE bad_temp AS SELECT DISTINCT * FROM your_table;
DELETE FROM your_table;
INSERT INTO your_table SELECT * FROM bad_temp;

-- Deduplication on some rows
CREATE TEMPORARY TABLE bad_temp AS SELECT * FROM your_table GROUP BY field1, field2, field3;
DELETE FROM your_table;
INSERT INTO your_table SELECT * FROM bad_temp;