php - MySQL: Syntax error when creating trigger -

why sql syntax throwing error?

create trigger info after insert on inbox each row begin if substring(new.textdecoded,1,6)='telkom' insert outbox ( destinationnumber, coding, textdecoded, creatorid )values ( new.sendernumber, 'default_no_compression', (select nama data_dosen kode = substring(new.textdecoded,8,10)), '1');  else insert outbox (destinationnumber, coding, textdecoded, creatorid) values (new.sendernumber, 'default_no_compression', 'maaf format sms anda salah. ketik telkom<spasi>kode dosen', '1');  end if;  end$$ 

you have error in sql syntax; check manual corresponds mysql server version right syntax use near '' @ line 4

you don't have delimiter definition before trigger. delimiter informs mysql characters end trigger. without it, mysql assumes semicolon default delimiter , fails upon first semicolon in code. check out this:

delimiter $$ create trigger info after insert on inbox each row begin if substring(new.textdecoded,1,6)='telkom'     insert outbox ( destinationnumber, coding, textdecoded, creatorid )values ( new.sendernumber, 'default_no_compression', (select nama data_dosen kode = substring(new.textdecoded,8,10)), '1');  else     insert outbox (destinationnumber, coding, textdecoded, creatorid) values (new.sendernumber, 'default_no_compression', 'maaf format sms anda salah. ketik telkom<spasi>kode dosen', '1');  end if;  end$$ delimiter ;