MySQL 触发器调用存储过程
时间: 2023-05-28 16:08:14 浏览: 371
MySQL 触发器可以调用存储过程,实现对数据库的自动化操作。以下是 MySQL 触发器调用存储过程的示例:
创建存储过程:
```
CREATE PROCEDURE update_customer_status(IN customer_id INT)
BEGIN
UPDATE customer SET status = 'inactive' WHERE id = customer_id;
END;
```
创建触发器:
```
CREATE TRIGGER trig_customer AFTER DELETE ON customer
FOR EACH ROW
BEGIN
CALL update_customer_status(OLD.id);
END;
```
以上触发器在每次删除 customer 表中的记录时,都会调用 update_customer_status 存储过程,将该记录的状态设置为“inactive”。
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![txt](https://img-home.csdnimg.cn/images/20210720083642.png)
![pptx](https://img-home.csdnimg.cn/images/20210720083543.png)
![exe](https://img-home.csdnimg.cn/images/20210720083343.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)