Erro na trigger

[Renato Penna]

O que há de errado com esta trigger ? DELIMITER ; CREATE TRIGGER Update_Status AFTER UPDATE ON sales_order FOR EACH ROW BEGIN IF OLD.status <> NEW.status AND (NEW.status = 20 OR NEW.status = 27 OR NEW.status = 30) THEN INSERT INTO order_status(orders,current_status,momento_captura,check_link)VALUES(NEW.partner_order_id,NEW.status,(SELECT CONCAT(DATE(NOW()),' ',TIME(NOW()))),(SELECT content_url FROM book b INNER JOIN sales_order_item soi ON b.id = soi.book_id INNER JOIN sales_order so ON soi.order_id = so.id WHERE so.id = NEW.id)); INSERT INTO order_status(orders,current_status,momento_captura,check_link)VALUES(NEW.partner_order_id,NEW.status,(SELECT CONCAT(DATE(NOW()),' ',TIME(NOW()))),(SELECT cover_url FROM book b INNER JOIN sales_order_item soi ON b.id = soi.book_id INNER JOIN sales_order so ON soi.order_id = so.id WHERE so.id = NEW.id)); END IF; END; Quando eu a executo recebo o erro: Erro consulta SQL: Documentação DELIMITER; CREATE TRIGGER Update_Status AFTER UPDATE ON sales_order FOR EACH ROW BEGIN IF OLD.status <> NEW.status AND ( NEW.status =20 OR NEW.status =27 OR NEW.status =30 ) THEN INSERT INTO order_status( orders, current_status, momento_captura, check_link ) VALUES ( NEW.partner_order_id, NEW.status, ( SELECT CONCAT( DATE( NOW( ) ) , ' ', TIME( NOW( ) ) ) ), ( SELECT content_url FROM book b INNER JOIN sales_order_item soi ON b.id = soi.book_id INNER JOIN sales_order so ON soi.order_id = so.id WHERE so.id = NEW.id ) ); Mensagens do MySQL : Documentação #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7

[Denis Courcy]

Você não tocou os delimitadores de final de linha. (Os que informam que a instrução chegou ao fim).

O correto é

DELIMITER $$; /*o delimitador trocou de ; para $$. (pode se qualquer outro a seu criterio)*/

DROP TRIGGER `banco`.`nometrigger`$$

CREATE TRIGGER `banco`.`nometrigger` BEFORE/AFTER INSERT/UPDATE/DELETE on `sase`.`preco`
FOR EACH ROW BEGIN
/*aqui todas as instruções finalizam com ; */
END$$

DELIMITER ;$$/*o delimitador volta a ser ;*/