INSERT INTO mksc_product_price (row_id,store_no,product_no,tag_price,retail_price)
VALUES (uuid_short(),'Y416','B1401010-FC',777,888),
(uuid_short(),'Y416','B1401010',777,888)
ON DUPLICATE KEY UPDATE tag_price = VALUES(tag_price),retail_price=VALUES(retail_price);
VALUES (uuid_short(),'Y416','B1401010-FC',777,888),
(uuid_short(),'Y416','B1401010',777,888)
ON DUPLICATE KEY UPDATE tag_price = VALUES(tag_price),retail_price=VALUES(retail_price);