mysql 触发器 分行_mysql 触发器

mysql 触发器中有两个insert 语句 第二个inert 要用第一个insert 的结果怎么实现

DELIMITER $$

USE `nightclub`$$

DROP TRIGGER /*!50032 IF EXISTS */ `create_histroy_room_statuses`$$

CREATE

/*!50017 DEFINER = 'root'@'localhost' */

TRIGGER `create_histroy_room_statuses` BEFORE DELETE ON `room_statuses`

FOR EACH ROW

BEGIN

INSERT `nightclub`.histroy_room_statuses (

room_id,

note,

customer_number,

arrival_time,

room_game,

drinks,

booking_time,

estimated_time,

assistant_table,

visitor,

cadres_patrol,

salesman_tip,

master_tip,

princess_tip,

drink_total,

prs_tip_total,

towel_number,

consume,

pay_method,

princess_customer_tel,

princess_customer_name,

createdAt,

updatedAt,

booking_employee_id,

princess_id,

salesman_id,

master_id,

booking_customer_tel,

booking_customer_name,

state,

enter_time

) SELECT

room_id,

note,

customer_number,

arrival_time,

room_game,

drinks,

booking_time,

estimated_time,

assistant_table,

visitor,

cadres_patrol,

salesman_tip,

master_tip,

princess_tip,

drink_total,

prs_tip_total,

towel_number,

consume,

pay_method,

princess_customer_tel,

princess_customer_name,

createdAt,

updatedAt,

booking_employee_id,

princess_id,

salesman_id,

master_id,

booking_customer_tel,

booking_customer_name,

state,

enter_time

FROM `nightclub`.room_statuses

WHERE room_id = old.room_id;

INSERT INTO histroy_room_status_prs (

employee_id,

room_id,

createdAt,

updatedAt,

customer_name,

customer_tel,

isExemptFee,

charge,

work_time

) SELECT

employee_id,

room_id,

createdAt,

updatedAt,

customer_name,

customer_tel,

isExemptFee,

charge,

work_time

FROM

room_status_prs WHERE room_id=old.room_id;

END;

$$

DELIMITER ;

histroy_room_status_prs 表我建立外键 但是获取不到第一个insert 返回的值 该怎么实现 那位高手指点一下谢谢