ECNU数据库作业——Lab7

yushan.ji

于 2024-01-18 14:57:30 发布

阅读量869

点赞数 16

分类专栏：数据库原理与实践文章标签：数据库

本文链接：https://blog.youkuaiyun.com/Yushan_Ji/article/details/135674747

版权

文章介绍了五个MySQL触发器示例，分别用于在新部门插入、经理年龄更新、部门删除时自动管理临时经理、减少相应部门预算以及自动更新创建日期。这些触发器确保了数据一致性并简化了数据库操作流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Lab 7

EX1

Create a trigger that, when a new department is inserted into the department table, automatically assigns a temporary manager to that department in the management table.

DELIMITER//
CREATE TRIGGER ex1
AFTER INSERT ON department
FOR EACH ROW
BEGIN
	-- 随机选取一个manager
	DECLARE new_head INT;
	SET new_head = (SELECT head_ID FROM head ORDER BY RAND() LIMIT 1);
	INSERT INTO management VALUES(new.Department_ID, new_head, 'Yes');
END//

DELIMITER;
INSERT INTO department VALUES(16, 'Test name', 2023, 16, 0, 0

最低0.47元/天解锁文章