Error in mysql while creating a trigger

Question

I have two table stock detail and purchase.

When I'm trying to create a trigger on the table purchase it will seems an error that

"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 "

Hear is my code

create TRIGGER afterinsert after insert on purchase for each row
BEGIN 
set @qnty=(select quantity from stock_detail where brand_name = new.brand);
if(@qnty>=1) then
update stock_detail set quantity=@qnty+new.quanty;
end if;
END;

I dont see any delimiter for the trigger. If you write the trigger on mysql CLI then you need to set the delimiter other than the default one which is ; so you need delimiter // at the top and finally END;// delimiter ; — Abhik Chakraborty
– Abhik Chakraborty, Commented Feb 18, 2016 at 7:22
are you setting the delimiter before creating the trigger? dev.mysql.com/doc/refman/5.0/en/trigger-syntax.html — Sandy
– Sandy, Commented Feb 18, 2016 at 7:22

Sandy · Accepted Answer · 2016-02-18 07:39:48Z

0

Try this:

delimiter //
create TRIGGER afterinsert after insert on purchase for each row
BEGIN 
set @qnty=(select quantity from stock_detail where brand_name = new.brand);
if(@qnty>=1) then
update stock_detail set quantity=@qnty+new.quanty;
end if;
END;//
delimiter ;

For more info refer: http://dev.mysql.com/doc/refman/5.0/en/trigger-syntax.html

edited Feb 18, 2016 at 7:39

answered Feb 18, 2016 at 7:29

Sandy

1,0533 gold badges21 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error in mysql while creating a trigger

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related