Membuat dan Menampilkan Trigger
TUGAS 7 MANAJEMEN BASIS DATA "Membuat dan Menampilakn TRIGGER" Disusun Oleh : INGGIT NADYA NASTITI 160101243 STMIK DUTA BANGSA SURAKARTA 2018 ______________________________________________ mysql> create table beli ( -> id_beli int (11) not null auto_increment primary key, -> kd_barang varchar (10), -> satuan double, -> jumlah int (11), -> total double, -> status varchar (30)); Query OK, 0 rows affected (0.65 sec) mysql> desc beli; +-----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+----------------+ | id_beli | int(11) | NO | PRI | NOT NULL| auto_increment | | kd_barang | varchar(10) | YES | | NULL | | | satuan | double | YES | | NULL | | | jumlah | int(11) | YES | | NUL