Use Procedure instead of trigger in MySQL

iszxjhcz 于 2022-12-22 发布在 Mysql

关注(0)|答案(1)|浏览(116)

I'm trying to make trigger to update one field in inserted row but even with this answer: https://stackoverflow.com/a/15300941/4018940 i cant make it work.
Every time i get error:
General error: 1442 Can't update table 'people' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
Here is my code:

CREATE TRIGGER short_name_trigger
BEFORE INSERT ON `people`
FOR EACH ROW BEGIN
UPDATE `people` SET NEW.short_name = "wohahaha";
END

Is there any chance that stored procedure will make it work? How to write that procedure?

mysql

来源：https://stackoverflow.com/questions/74836853/use-procedure-instead-of-trigger-in-mysql

1条答案

按热度按时间

kyxcudwk1#

If you want to change the value being inserted in the new row, you don't need to use UPDATE people . Just set NEW.short_name and this will replace the value that's being inserted.

CREATE TRIGGER short_name_trigger
BEFORE INSERT ON `people`
FOR EACH ROW BEGIN
    SET NEW.short_name = "wohahaha";
END

赞(0）回复(0）举报 2022-12-22

我来回答

Use Procedure instead of trigger in MySQL

1条答案

相关问题

热门标签

最新问答