I want to add triggers on to my sql but am unable to do it I go through videos online but they are making use of my sql work bench which wasnt suitable for me using xampp SQL query: Copy
DELIMITER//
create trigger dave
after insert on codeweb
for each ROW
begin
if new.salary <=0 then update new.salary from codeweb set new.salary='10000';
This is what am seeing MySQL said: Documentation
#1064 - 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 dave after insert on codeweb for each ROW begi...' at line 1 this is my code DELIMITER// create trigger dave after insert on codeweb for each ROW begin if new.salary <=0 then update new.salary from codeweb set new.salary='10000' end if; end// // select*from codeweb