SISTEM DATA BASE
1. Contoh Syntax Trigger mysql> 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) 2. Contoh Syntax Store Procedure CREATE [ DEFINER = { user | CURRENT_USER } ] PROCEDURE sp_name ( proc_parameter [,...]) [characteristic ...] routine_body 3. Contoh Syntax Delimiter DELIMITER // CREATE FUNCTION FortyTwo() RETURNS TINYINT DETERMINISTIC BEGIN DECLARE x TINYINT; SET x = 42; RETURN x; END // DELIMITER ;