Predmet:Re: Trigeri-okidaci (triggers)

---

CREATE TABLE account (acct_num INT, amount DECIMAL(10,2));
Query OK, 0 rows affected (0.03 sec)
mysql> CREATE TRIGGER ins_sum BEFORE INSERT ON account
-> FOR EACH ROW SET @sum = @sum + NEW.amount;
Query OK, 0 rows affected (0.06 sec)
Sad je kreiran triger. Testirajmo njegov rad.
mysql> SET @sum = 0;
mysql> INSERT INTO account VALUES(137,14.98),(141,1937.50),(97,-100.00);
mysql> SELECT @sum AS 'Total amount inserted';
+-----------------------+
| Total amount inserted |
+-----------------------+
| 1852.48 |
+-----------------------+
vrednost promenljive @sum (zbog parametara naredbe INSERT) je 14.98 + 1937.50 - 100,
to jest 1852.48.
Uklanjanje trigera sa DROP TRIGGER. Mora se navesti ime sheme (sem ako nije
podrazumevana).

---