rianto isaac's Weblog

rianto utomo isaac sahala utomo

php-mysql, create trigger in mysql

leave a comment »

create trigger replay AFTER INSERT on inbox
for each row BEGIN

if new.text = ’info’ then
insert into outbox value(new.number,’Terimakasih atas pilihan anda’);
end if;

if new.text = ’kota’ then
insert into outbox value(new.number,’Terimakasih atas pilihan anda’);
end if;
end$

rianto utomo bole nyontek dari http://www.diskusiweb.com/viewthread.php?tid=42661

Written by isaaconi

September 9, 2009 pada 9:32 am

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: