- Beranda
- Komunitas
- Tech
- Programmer Forum
(Pertanyaan) Trigger
TS
tanto415
(Pertanyaan) Trigger
Mohon pencerahannya dong para suhu programmer, saya lagi belajar membuat trigger di SQL dan belum berhasil mungkin karna syntaxnya yg salah ato emang caranya yg salah, trigger tersebut berfungsi mengupdate total barang yg terjual.
Saya buat 2 tabel :
Tabel_barang
-id
-kode_barang
-nama_barang
-total_penjualan
Tabel_penjualan_barang
-id
-kode_barang
-terjual
-tanggal
saya buat trigger di tabel_penjualan_barang begini scriptnya :
==================================================================
ELIMITER $$
CREATE TRIGGER totalpenjualan_barang
AFTER UPDATE
ON tabel_penjualan_barang
FOR EACH ROW
BEGIN
DECLARE kode INT;
DECLARE jual INT;
SELECT kode = kode_barang, jual = SUM(terjual)FROM tabel_penjualan_barang GROUP BY kode_barang;
IF jual IS NOT NULL
UPDATE tabel_barang SET total_penjualan = jual WHERE kode_barang = kode;
END$$
DELIMITER ;
==================================================================
pesan errornya :
====================================================================
Query : ELIMITER $$ CREATE TRIGGER totalpenjualan_barang AFTER UPDATE ON tabel_penjualan_barang FOR EACH ROW BEGIN DE...
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ELIMITER $$
CREATE TRIGGER totalpenjualan_barang
AFTER UPDATE
ON tabel_p' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
==================================================================
saya sudah coba puluhan kali berexperiment ganti ini itu tapi masih gagal terus, mohon pencerahannya para suhu.. trimakasih.
Saya buat 2 tabel :
Tabel_barang
-id
-kode_barang
-nama_barang
-total_penjualan
Tabel_penjualan_barang
-id
-kode_barang
-terjual
-tanggal
saya buat trigger di tabel_penjualan_barang begini scriptnya :
==================================================================
ELIMITER $$
CREATE TRIGGER totalpenjualan_barang
AFTER UPDATE
ON tabel_penjualan_barang
FOR EACH ROW
BEGIN
DECLARE kode INT;
DECLARE jual INT;
SELECT kode = kode_barang, jual = SUM(terjual)FROM tabel_penjualan_barang GROUP BY kode_barang;
IF jual IS NOT NULL
UPDATE tabel_barang SET total_penjualan = jual WHERE kode_barang = kode;
END$$
DELIMITER ;
==================================================================
pesan errornya :
====================================================================
Query : ELIMITER $$ CREATE TRIGGER totalpenjualan_barang AFTER UPDATE ON tabel_penjualan_barang FOR EACH ROW BEGIN DE...
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ELIMITER $$
CREATE TRIGGER totalpenjualan_barang
AFTER UPDATE
ON tabel_p' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
==================================================================
saya sudah coba puluhan kali berexperiment ganti ini itu tapi masih gagal terus, mohon pencerahannya para suhu.. trimakasih.
nona212 memberi reputasi
2
2K
17
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Urutan
Terbaru
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan