Mysql Trigger: Tried other suggestions but still get Error #1064 -

Mysql Trigger: Tried other suggestions but still get Error #1064 -

i've been looking @ other stackoverflow questions here cant seem find fault. think syntax-error related. on part did got wrong?

delimiter $$ drop trigger if exists keisan create trigger keisan after insert on profitdb each row begin declare shinagentpercent; set @shinagentpercent:=`agentrisk`-`subagentrisk`; set new.`subagentprofit` = `profit`*(`subagentrisk`/100); set new.`agentprofit` = `profit`*(@shinagentpercent/100); end; $$

firstly, need closing statement indication after drop ... command.

drop trigger if exists keisan $$

secondly, suggest go before insert trigger set look values other columns of tables.

example:

delimiter $$ drop trigger if exists keisan $$ create trigger keisan before insert on profitdb each row begin set @shinagentpercent := new.agentrisk - new.subagentrisk; set new.subagentprofit := new.profit * ( new.subagentrisk / 100 ); set new.agentprofit := new.profit * ( @shinagentpercent / 100 ); end; $$ -- reset delimiter defaut delimiter ;

mysql triggers phpmyadmin