Scribd
Upload
14 views14 pages

SQL Triggers in MySQL Explained

The document discusses different types of SQL triggers in MySQL, including triggers that are triggered on insert, update, and delete operations and can perform insert, update, delete, or other actions in response. It provides examples of trigger scripts for inserting into backup tables in response to inserts or updates into source tables, updating or deleting rows in other tables in response to DML operations, and more complex triggers with branching or looping logic.

Uploaded by

Wakhid Kurniawan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
14 views14 pages

SQL Triggers in MySQL Explained

The document discusses different types of SQL triggers in MySQL, including triggers that are triggered on insert, update, and delete operations and can perform insert, update, delete, or other actions in response. It provides examples of trigger scripts for inserting into backup tables in response to inserts or updates into source tables, updating or deleting rows in other tables in response to DML operations, and more complex triggers with branching or looping logic.

Uploaded by

Wakhid Kurniawan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SQL TRIGGER MYSQL

Berikut macam-macam sql trigger, antara lain:


1 Trigger bila dipicu insert- maka insert.
Script Trigger Insert-Insert:

Script insert pada tabel obat :

Hasil pada tabel obat_backup (membuat tabel baru):

Edited : [Link]

Trigger bila dipicu insert- maka update.


Script Trigger Insert-Update

Gambar pada tabel stock_obat sebelum insert rincian_pembelian.

Script insert rincian_pembelian

Tabel tabel stock_obat sesudah insert rincian_pembelian :

Edited : [Link]

Trigger bila dipicu insert- maka delete.


Script Trigger Insert-Delete.

Tabel pelanggan_backup (membuat tabel baru)


pelanggan

sebelum insert

Script insert

Tabel pelanggan_backup sesudah insert

Edited : [Link]

Trigger bila dipicu update - maka insert.


Script Trigger Update-Insert.

Tabel sebelum update

Script update

Hasil sesudah di update

Edited : [Link]

Trigger bila dipicu update - maka update.


Script Trigger Update update

Tabel obat_backup (membuat tabel baru) sebelum update

Script update

Tabel obat_backup sesudah update

Edited : [Link]

Trigger bila dipicu update - maka delete.


Script Trigger Update delete

Tabel Stock_obat sebelum trigger berjalan

Script update

Edited : [Link]

11

Tabel Stock_obat setelah trigger berjalan

Edited : [Link]

13

Trigger bila dipicu delete - maka insert.


Script Trigger Delete insert

Tabel pelanggan_backup (membuat tabel baru) sebelum trigger


berjalan

Script delete

Hasil pada tabel pelanggan backup

Edited : [Link]

15

Trigger bila dipicu delete - maka update.


Script Trigger Delete update

Gambar sebelum trigger dieksekusi

Script delete

Hasil

Edited : [Link]

17

Trigger bila dipicu delete - maka delete.


Script Trigger Delete delete

Gambar sebelum

Script delete

Hasil

Edited : [Link]

19

10 Trigger yang terdapat percabangan if / elsif / else.


Script Trigger Branching

Table status obat sebelum trigger berjalan

Script

Tabel sesudah trigger berjalan

Edited : [Link]

21

Edited : [Link]

23

11 Trigger yang terdapat looping for / while / do while.


Script Trigger Looping

Table dokter backup (membuat tabel baru) sebelum trigger berjalan

Script Insert

Tabel dokter_backup sesudah trigger berjalan

Edited : [Link]

25

12 Trigger yang mampu melewatkan pesan trigger.


Script Trigger Message

Script

Hasil

Edited : [Link]

27

You might also like