search

Home  >  Q&A  >  body text

mysql - 执行sql语句跳过触发器

会员表里有一个修改的触发器,只要对它进行修改,就会把这一行数据添加到新建的一张表里。
有个判断条件,要是条件成立 执行sql语句修改,,就跳过触发器,求大神解决下

巴扎黑巴扎黑2873 days ago704

reply all(2)I'll reply

  • PHP中文网

    PHP中文网2017-04-17 16:21:16

    If you still need triggers but don’t want to use triggers at some point, there are two methods:
    1. Check what operations the trigger has. When some of your conditions are met, go to the newly created table Just delete the data generated by the trigger
    2. Modify the trigger. The trigger can also be IF ELSEIF ENDIF. Write the conditions into the trigger

    reply
    0
  • 阿神

    阿神2017-04-17 16:21:16

    Delete the trigger

    reply
    0
  • Cancelreply