MEMBUAT TRIGGER MYSQL STATEMENT
Langkah awal membuat tabel baru bernama employees_audit untuk menyimpan perubahan pada tabel employees: CREATE TABLE employees_audit ( id INT AUTO_INCREMENT PRIMARY KEY, employeeNumber INT NOT NULL, lastname VARCHAR(50) NOT NULL, changedat DATETIME DEFAULT NULL, action VARCHAR(50) DEFAULT NULL ); Berikutnya, buat trigger BEFORE UPDATE yang dipanggil sebelum perubahan dilakukan pada tabel employees. CREATE TRIGGER before_employee_update BEFORE UPDATE ON employees FOR EACH ROW INSERT INTO employees_audit SET action = 'update', employeeNumber = OLD.employeeNumber, lastname = OLD.lastname, changedat = NOW(); Dan selanjutnya perbarui baris di tabel employees: UPDATE employees SET lastName = 'Phan' WHERE employeeNumber = 1056;