mysql 触发器 不等号,MySql触发器不工作

我有三张桌子

tbl_payments(pay_id,date,amount,description,-------)

tbl_pay_trans(pay_id,trans_id)

tbl_transactions(trans_id,trans_date,trans_amount,trans_description,-----)

“tbl_transaction”具有来自“tbl_payments”的相同数据以及一些其他值。为了保持这两个表之间的关系,我使用“tbl_pay_trans”。我想做的是,当对tbl_付款(金额,说明)进行更新时,同样的更改需要在tbl_交易(交易金额,交易说明)中进行。为此我编写了一个触发器,但它并没有按预期更新tbl_事务表的值。

我的扳机是

DELIMITER $$

CREATE TRIGGER update_trans

AFTER UPDATE on tbl_payments

FOR EACH ROW

BEGIN

DECLARE new_amount VARCHAR(50);

DECLARE new_description TEXT;

DECLARE new_pay_id,new_trans_id INT;

SET new_pay_id = OLD.pay_id;

SET new_amount = OLD.amount;

SET new_description = OLD.description;

SELECT trans_id INTO new_trans_id FROM tbl_pay_trans WHERE pay_id = new_pay_id;

UPDATE tbl_transactions SET

trans_amount = new_amount,

trans_description = new_description

WHERE trans_id = new_trans_id;

END$$

DELIMITER ;

请有人帮我找出我做错了什么。