My trigger doesn't work

SQL
1

I followed Mosh’s code at my machine for Trigger and Insert.
I cannot find anything wrong from my scripts.

However, it just cannot work. Can anyone help?
Here is my code:

DELIMITER $$

CREATE TRIGGER payments_after_insert
AFTER INSERT ON payments
FOR EACH ROW
BEGIN
UPDATE invoices
SET payment_total = payment_total + NEW.amount
WHERE invoice_id = NEW.invoice_id;
END$$

DELIMITER ;

And the part for INSERT:
INSERT INTO payments
VALUES (DEFAULT, 5, 3, ‘2019-01-01’, 10, 1)

I execute the Trigger first and then the Insert part, but my invoices table just doesn’t update.
Anything wrong at my code?

2

I changed the code as below and it finally works.

DELIMITER //

CREATE TRIGGER payments_after_insert
AFTER INSERT ON payments
FOR EACH ROW
BEGIN
UPDATE invoices
SET payment_total = payment_total + NEW.amount
WHERE invoice_id = NEW.invoice_id;
END //

INSERT INTO payments
VALUES (DEFAULT, 5, 3, ‘2019-01-01’, 10, 1)

Even though no one answers, I do hope this can help someone facing the same problem as me.

Wish you great.

3

I still could not get to work with the above example either. When I executed SHOW TRIGGERS; it returned nothing so I researched further and looks like it has to do with access rights: mysql - Triggers hidden - Database Administrators Stack Exchange But I tried
USE sql_invoicing;

GRANT TRIGGER ON payments to ‘root’@‘localhost’;
which mySQL Workbench said was all fine and dandy, But SHOW TRIGGERS; returned nothing and my trigger did not fire. I also see there are access permissions at the schema level which had TRIGGER checked. I checked all the others and applied but still no dice. mySQL Workbench 8.0. I am wondering do I have to recreate the trigger once again? Hello? Anyone? Bueller?