If you get a SQL dump of a database table and want to update part of the data into existing table, you can use the following SQL statement to achieve it.
INSERT INTO `t_products` (`productid`, `prodname_en`, `proddesc_en`) VALUES(222, ‘This is the product name’, ‘This is the product description’) ON DUPLICATE KEY UPDATE some_column1=VALUES(prodname_en), some_column2=VALUES(proddesc_en);
Reference: http://nerkn.mornehir.com/multiple-duplicate-key-update