-- 创建职工表
CREATE TABLE employees (
emp_id INT PRIMARY KEY,
emp_name VARCHAR(50),
emp_gender VARCHAR(10),
emp_age INT
);
-- 创建职工工资表
CREATE TABLE salaries (
salary_id INT AUTO_INCREMENT PRIMARY KEY,
emp_id INT,
base_salary DECIMAL(10, 2),
FOREIGN KEY (emp_id) REFERENCES employees(emp_id)
);
-- 创建触发器,实现对职工信息的同步操作
DELIMITER //
CREATE TRIGGER sync_employee_info
AFTER INSERT ON employees
FOR EACH ROW
BEGIN
INSERT INTO salaries (emp_id, base_salary)
VALUES (NEW.emp_id, 10000);
END //
DELIMITER ;
-- 创建触发器,实现对职工信息的同步操作
DELIMITER //
CREATE TRIGGER update_employee_info
AFTER UPDATE ON employees
FOR EACH ROW
BEGIN
UPDATE salaries
SET emp_id = NEW.emp_id
WHERE emp_id = OLD.emp_id;
END //
DELIMITER ;
-- 创建触发器,实现对职工信息的同步操作
DELIMITER //
CREATE TRIGGER delete_employee_info
AFTER DELETE ON employees
FOR EACH ROW
BEGIN
DELETE FROM salaries
WHERE emp_id = OLD.emp_id;
END //
DELIMITER ;
创建职工表以及职工工资表
![](https://img-home.csdnimg.cn/images/20240711042549.png)