issue in the Trigger … You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘delimiter $$
create trigger add_not_before_insert
before insert on `customer…’ at line 1
Hi, I am trying to insert a value in the column Note
inside the table customer_payments
using if statement inside the trigger, For customer who has previous payment … Enter the word ‘monthly installments’ in the column Note
; but if it is the first time for this customer! Enter the word ‘first time’ in the Note’s column
all the tables and the trigger attached to the :
https://dbfiddle.uk/fc-4QQRF