mysql触发器使用实例详解数据库

DELIMITER $$ 
 
USE `db`$$ 
 
DROP TRIGGER `member_walletinit_trigger`$$ 
 
CREATE TRIGGER `member_walletinit_trigger` AFTER INSERT ON `member`  
    FOR EACH ROW BEGIN 
        SET @count = (SELECT COUNT(mem_no) FROM `wallet` WHERE mem_no = NEW.reg_no);   
    IF @count = 0 THEN   
      INSERT INTO wallet (mem_no)VALUE(NEW.reg_no); 
    END IF; 
    END; 
$$ 
 
DELIMITER ;