mysql中的表中插入数据后如何触发触发器
我想在我的表填满记录后触发触发器,我不想触发按行触发器。
请告诉我们如何在 mysql 中做到这一点?
I want to fire a trigger after my table has been filled with records ,I don't want to fire a row-wise trigger.
Please tell how can we do that in mysql?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
更新:
FOR EACH ROW 选项确定触发器是行触发器还是语句触发器。如果指定 FOR EACH ROW,则触发器将为受触发语句影响的表的每一行触发一次。缺少 FOR EACH ROW 选项表示触发器仅针对每个适用的语句触发一次,而不是针对受该语句影响的每一行单独触发。
Updated:
The FOR EACH ROW option determines whether the trigger is a row trigger or a statement trigger. If you specify FOR EACH ROW, then the trigger fires once for each row of the table that is affected by the triggering statement. The absence of the FOR EACH ROW option indicates that the trigger fires only once for each applicable statement, but not separately for each row affected by the statement.