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.