Arsip: [HINT] Trigger dan Store Procedure In mySQL.

more 17 years ago
cyber_hecker
permintaan seseorang untuk memberikan contoh sederhana penggunaan trigger dan store procedure.
contoh trigger sederhana :
[sql:1:beafe12bb2]-- Table: tb_customer
-- DROP TABLE tb_customer;
CREATE TABLE tb_customer (
id_cust varchar(3) NOT NULL,
nm_cust varchar(50),
alamat_cust varchar(50),
updated date,
status varchar(10),
/ Keys /
PRIMARY KEY (id_cust)
) ENGINE = InnoDB;
CREATE UNIQUE INDEX id_cust
ON tb_customer
(id_cust);
DELIMITER |
CREATE DEFINER = 'root'@'localhost' TRIGGER trig_inserting
BEFORE INSERT
ON tb_customer
FOR EACH ROW
BEGIN
/ Trigger text /
SET New.updated = NOW();
SET NEW.status = 'BARU';
END|
DELIMITER ;
DELIMITER |
CREATE DEFINER = 'root'@'localhost' TRIGGER trig_updating
BEFORE UPDATE
ON tb_customer
FOR EACH ROW
BEGIN
/ Trigger text /
SET NEW.updated = NOW();
SET NEW.status = 'UPDATE';
END|
DELIMITER ;[/sql:1:beafe12bb2]
trigger ini berfungsi untuk update nilai yang baru dimasukkan / edit pada field updated -> di isi tanggal insert / update, dan status -> status apakah update atau baru.
kelebihan trigger (menurutku) :D :
- mengurangi beban jaringan.. karena pengiriman data lebih sedikit. harusnya 5 jadi 3 data yang dikirim, 2 field di kerjakan di server.
kekurangan trigger (menurutku) :D :
- sulit melakukan pembacaan kode program. karena tanpa ada perintah kok ada field yang berubah. apa gak bingung tuh.
contoh store procedure sederhana :
[sql:1:beafe12bb2]-- Procedure: sp_ins_customer
-- DROP PROCEDURE sp_ins_customer;
DELIMITER |
CREATE PROCEDURE sp_ins_customer
(
IN pid_cust varchar(2),
IN pnm_cust varchar(50),
IN palamat_cust varchar(50)
)
COMMENT 'MEMASUKKAN NILAI KE TABEL CUSTOMER'
BEGIN
/ Procedure text /
INSERT tb_customer
(id_cust, nm_cust, alamat_cust)
VALUES
(pid_cust, pnm_cust, palamat_cust);
END|
DELIMITER ;[/sql:1:beafe12bb2]
cara pemanggilan :
CALL sp_ins_customer('04','CAPPUCINO','JL. KUBURAN 55');
kelebihan store procedure :
- mempersingkat kode di program, gak usah ngetik banyak-banyak perintah SQL.
kekurangan store procedure :
- lom tau nih... coba sendiri dan berikan pendapatmu !!!

more 17 years ago
mas_kofa
aku lebih suka pake fungsi "generate sql str " yang aku bangun sendiri sesuai kebutuhanku.........
selain bisa menyingkat coding...juga bisa menghindari penggunaan "trigger"..................
kekurangan cara diatas......adalah kita harus berpikir keras u/ membangun fungsi tersebut.........

more 17 years ago
onsir
CREATE PROCEDURE sp_ins_customer
(
IN pid_cust varchar(2),
IN pnm_cust varchar(50),
IN palamat_cust varchar(50)
)
COMMENT 'MEMASUKKAN NILAI KE TABEL CUSTOMER'
BEGIN
/ Procedure text /
INSERT tb_customer
(id_cust, nm_cust, alamat_cust)
VALUES
(pid_cust, pnm_cust, palamat_cust);
END|
DELIMITER ;
klw cth di atas, bagaimana caranya nilai values di isi dari txtKode.Text, txtnama.Text, txtalamat.Text
apakah harus di modifikasi lagi ?
terima kasih atas penjelasanya.

more 17 years ago
saysansay
Xixixixixi Para Master Gi BerExperiment Nech..Ikutan ach....Untuk Om @Onsir PenggunaanNya Kira2 Seperti Ini Kalu Pake Zeos
ZStoredProc1.ParamByName('pid_cust').AsString=txtKode.Text
Dan Selanjutnya Experiment Sendiri Dunk...kekekekekekekemore ...
- Pages:
- 1
reply |
Report Obsolete
AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- mengabungkan coding 2 modul ke 1 function di file .DLL
by CAHYADI_ONG in Tip n Trik Pemrograman more 16 years ago - Barcode
by newbiez in Hal umum tentang Pascal Indonesia more 18 years ago - Tanya wireless
by Apakekdah in Network, Files, I/O & System more 18 years ago - Happy Ramadhan
by LuriDarmawan in OOT more 19 years ago - trouble network database
by ImanD in MySQL more 16 years ago - Mau Tanya
by Kijokotopo in Hal umum tentang Pascal Indonesia more 17 years ago - Problem akses .net web services via BDS 2006 for win32
by andipurwito in Tip n Trik Pemrograman more 17 years ago - [Help] Listbox -> bikin 2 baris dalam satu item
by abichoy in Tip n Trik Pemrograman more 17 years ago - error koneksi mysql dari client ke server
by azharz in MySQL more 15 years ago - Error Msjtest40.dll......help.....
by fissas in Hal umum tentang Pascal Indonesia more 16 years ago