-------------- UPDATE user_groups SET discount_percentage = 10.00 WHERE id = 1 AND name = 'Clienti' -------------- ERROR 1054 (42S22) at line 6: Unknown column 'discount_percentage' in 'SET' -------------- INSERT INTO product_group_prices (product_id, user_group_id, price) SELECT gp.id AS product_id, 1 AS user_group_id, ROUND(ps_p.price - sp.reduction, 2) AS price FROM gibertini_dump1.ps_specific_price sp JOIN gibertini_dump1.ps_product ps_p ON ps_p.id_product = sp.id_product JOIN gibertini_prova.products gp ON gp.sku = ps_p.reference WHERE sp.id_group = 3 AND sp.reduction_type = 'amount' AND sp.id_shop = 1 AND sp.id_customer = 0 AND (ps_p.price - sp.reduction) > 0 ON DUPLICATE KEY UPDATE price = VALUES(price) -------------- ERROR 1146 (42S02) at line 11: Table 'gibertini_prova.product_group_prices' doesn't exist