create trigger ins_notification after insert on transaction_detail
for each row
Begin
insert into sell_notifications(user_id, product_id, quantity)
values(new.transaction_id , new.product_id, new.quantity);
End;
Can any one see where's the problem? :(
Probably you forgot to change the delimiter before creating the trigger.
DELIMITER //
create trigger ins_notification after insert on transaction_detail
for each row
Begin
insert into sell_notifications(user_id, product_id, quantity)
values(new.transaction_id , new.product_id, new.quantity);
End //
DELIMITER ;
Though this would be much easier to verify if you showed us the error message instead of let us grope in the dark.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.