PHP 将用户 ID 传递给 mysql 触发器
我需要创建一个日志表，正如预期的那样，我需要存储用户 ID 以及旧的和新的行值.
I need to create a log table and as expected I need to store the user id and the old and new row values.
问题是我想创建一个触发器来对我执行此操作，但我知道无法将参数发送到触发器.
The thing is that I want to create a trigger to do that to me but I know that is not possible to send parameters to triggers.
有没有办法做到这一点?
Is there a way to do that?
在此先感谢您的帮助.
推荐答案
另一个技巧:你可以使用基于连接的变量 @var.
Another hack: you can use connection based variable @var.
示例:
set @user_id = 321
update table .....
set @user_id = null;
并且在更新触发器中你可以使用这个变量@user_id.
and in update trigger you can use this variable @user_id.
相关文章