MySQL 更新触发器不起作用

Question

DELIMITER $$
USE `mydb`$$
DROP TRIGGER /*!50032 IF EXISTS */ `update`$$
CREATE
/*!50017 DEFINER = 'root'@'localhost' */
TRIGGER `update` AFTER UPDATE
ON `users`
FOR EACH ROW BEGIN
UPDATE `users2` SET `users2`.`username` = new.username AND `users2`.`password` = new.password WHERE `users2`.`id` = new.id;
END;
$$

它不会产生任何错误，也不会完成它的工作。

Answer 1

您的UPDATE语句不正确。

更改自

UPDATE `users2` SET `users2`.`username` = new.username AND `users2`.`password` = new.password WHERE `users2`.`id` = new.id;
                                                       ^^^

到

UPDATE `users2`       
   SET `username` = new.username, `password` = new.password 
 WHERE `users2`.`id` = new.id;