mysql> DROP TRIGGER product_after_delete;
ERROR 1360 (HY000): Trigger does not exist
mysql> delimiter |
mysql> CREATE TRIGGER product_after_delete
-> AFTER DELETE ON product
-> FOR EACH ROW
-> BEGIN
-> delete from product_reverse where product_id=OLD.product_id;
-> END;|
ERROR 1359 (HY000): Trigger already existsmysql>
(
Read more... )