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 : G.R.A.M.united 1
Welcome message from author
This document is posted to help you gain knowledge. Please leave a comment to let me know what you think about it! Share it to your friends and learn new things together.
Transcript
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 : G.R.A.M.united 1
2. 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 :
2 Edited : G.R.A.M.united
3. Trigger bila dipicu insert- maka delete.
Script Trigger Insert-Delete.
Tabel pelanggan_backup (membuat tabel baru) sebelum insert pelanggan
Script insert
Tabel pelanggan_backup sesudah insert
Edited : G.R.A.M.united 3
4. Trigger bila dipicu update - maka insert.
Script Trigger Update-Insert.
Tabel sebelum update
Script update
Hasil sesudah di update
4 Edited : G.R.A.M.united
5. 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 : G.R.A.M.united 5
6. Trigger bila dipicu update - maka delete.
Script Trigger Update delete
Tabel Stock_obat sebelum trigger berjalan
Script update
6 Edited : G.R.A.M.united
Tabel Stock_obat setelah trigger berjalan
Edited : G.R.A.M.united 7
7. 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
8 Edited : G.R.A.M.united
8. Trigger bila dipicu delete - maka update.
Script Trigger Delete update
Gambar sebelum trigger dieksekusi
Script delete
Hasil
Edited : G.R.A.M.united 9
9. Trigger bila dipicu delete - maka delete.
Script Trigger Delete delete
Gambar sebelum
Script delete
Hasil
10 Edited : G.R.A.M.united
10. Trigger yang terdapat percabangan if / elsif / else.
Script Trigger Branching
Table status obat sebelum trigger berjalan
Script
Tabel sesudah trigger berjalan
Edited : G.R.A.M.united 11
12 Edited : G.R.A.M.united
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 : G.R.A.M.united 13
12. Trigger yang mampu melewatkan pesan trigger.
Script Trigger Message
Script
Hasil
14 Edited : G.R.A.M.united
Related Documents
