11111

触发器 

当删除商品表时自动删除库存表里的记录

CREATE
    /*[DEFINER = { user | CURRENT_USER }]*/
    TRIGGER `jxcxt`.`my trigger` BEFORE DELETE
    ON `jxcxt`.`goods`
    FOR EACH ROW BEGIN
DELETE FROM `kucuns` WHERE `gid=` old.gid
    END$$
DELIMITER ;

当新增学生时自动处理姓名拼音缩写。

CREATE
    /*[DEFINER = { user | CURRENT_USER }]*/
    TRIGGER `jxcxt`.`my trigger` AFTER INSERT
    ON `j<数据库名>`.`学生`
    FOR EACH ROW BEGIN
INSERT INTO 学生(姓名拼音缩写)VALUES(pysx(new.姓名));
    END$$

DELIMITER ;

DELIMITER $$
CREATE
    /*[DEFINER = { user | CURRENT_USER }]*/
    TRIGGER `employee`.`user_insert_trigger` AFTER INSERT
    ON `employee`.`user`
    FOR EACH ROW BEGIN
    INSERT INTO `user_logs` (`id`,`operation`,`operate_time`,`operate_id`,`operate_params`)VALUES
    (NULL,'insert',NOW(),new.id,CONCAT('插入的数据内容：id=',new.id,',name=',new.name,',age=',new.age,',gender=',new.gender,',phone=',new.phone));
    END$$
DELIMITER ;