MySQL5新特点(触发器)[MySQL防范]

mysql> delimiter // 
mysql> create trigger t_customer_insert before insert on customer
    -> for each row
    -> begin 
    -> set NEW.customer_ssn = aes_encrypt(NEW.customer_ssn,'password');
    -> end; 
    -> //
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;

mysql> insert into customer values (1,'fred','smith','456097234');
Query OK, 1 row affected (0.00 sec)
mysql> select * from customer;

mysql> delimiter // 
mysql> CREATE PROCEDURE cursor_demo()
    -> BEGIN 
    ->   DECLARE a, b CHAR(16); 
    ->   DECLARE cur1 CURSOR FOR SELECT id,data FROM test.t1;
    -> OPEN cur1; 
    -> REPEAT  
    ->  FETCH cur1 INTO a,b;
    -> UNDONE END REPEAT;
    -> CLOSE cur1; 
    -> END
    -> //

mysql> CREATE TABLE account (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER ins_sum BEFORE INSERT ON account
    -> FOR EACH ROW SET @sum = @sum + NEW.amount;