update the database query with ON DUPLICATE KEY UPDATE

Question

i am following this link :

Find entity_id & attribute_id of an attribute

I used this sql query :

INSERT INTO catalog_product_entity_varchar ( entity_type_id, attribute_id, store_id, entity_id, value) 
SELECT 10, 1021, 1, entity_id, value
FROM catalog_product_entity_int
WHERE attribute_id = 1021;

but i got error in the image :

@Marius suggested to use "ON DUPLICATE KEY UPDATE" . I have no idea about this. when i googled it, i got some solution, but that did't worked.

please give me the updated query using ON DUPLICATE KEY UPDATE

Answer 1

Bellow script run on magento root folder

<?php
require_once('app/Mage.php');
Mage::app('default');

class AR
{
    public function index()
    {
        $writeAdapter = Mage::getSingleton('core/resource')->getConnection('core_write');
        $readAdapter = Mage::getSingleton('core/resource')->getConnection('core_read');
        $resultAll = $readAdapter->fetchAll('SELECT `entity_type_id`,`attribute_id` ,`store_id`, `entity_id`, `value` FROM `catalog_product_entity_int` WHERE `attribute_id` =1021');
        foreach($resultAll as $result) {
             $writeAdapter->query('DELETE FROM `catalog_product_entity_varchar` WHERE `catalog_product_entity_varchar`.`attribute_id` =1021;');
            $query = "INSERT INTO `catalog_product_entity_varchar` (`value_id`, `entity_type_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (NULL, '".$result['entity_type_id']."', '".$result['attribute_id']."', '".$result['store_id']."', '".$result['entity_id']."', '".$result['value']."');";
         $writeAdapter->query($query);
        }

        echo 'Attribute values are updated.';  


    }

}

$obj = new AR();
$obj->index();
?>