Re: Can I execute if / then statements inside a trigger?

[Giannino Di Tizio]

Thanks Peter was solved like this:

DELIMITER //
CREATE TRIGGER `open_existencia` AFTER INSERT ON `productos`
FOR EACH ROW BEGIN
IF NEW.tipo_producto = 'X' THEN
INSERT INTO existencias(producto_id) VALUES (NEW.id);
END IF;
END; //
DELIMITER ;