i´m trying to create trigger for update column, resulting of the min value of other columns. My sql code it´s the following:
DELIMITER //
CREATE TRIGGER t__price_final AFTER UPDATE ON market__combination_price
FOR EACH ROW
BEGIN
CASE
WHEN market__combination_price.price <= market__combination_price.offer
THEN UPDATE market__combination_price SET price_final =
market__combination_price.price;
WHEN market__combination_price.price > market__combination_price.offer
THEN UPDATE market__combination_price SET price_final =
market__combination_price.offer;
END CASE;
END;
//
But it doesn´t work. What could be the problem?