auto reply dan update

create trigger otomatis after insert on inbox
for each row begin

if (select count(*) from inbox where SenderNumber=new.SenderNumber and TextDecoded=new.TextDecoded) > 1 then

insert into outbox (DestinationNumber,TextDecoded) values (new.SenderNumber , 'Anda sudah pernah Memilih');

elseif (select count(*) from inbox where SenderNumber=new.SenderNumber and TextDecoded=new.TextDecoded) = 0 then

update poll set Jumlah = Jumlah + 1 where Kode=new.TextDecoded;
insert into outbox (DestinationNumber,TextDecoded) values (new.SenderNumber , 'Terima Kasih Pilihan Anda Sudah Tersimpan');

elseif (select count(*) from poll where Kode=new.TextDecoded) = 0 then

insert into outbox (DestinationNumber,TextDecoded) values (new.SenderNumber , 'Pilihan anda tidak ada dalam list');

end if;

end$$