Problem event update or delete multiple effected rows

rodrigogs / mysql-events

A node package that watches a MySQL database and runs callbacks on matched events.

BSD 3-Clause "New" or "Revised" License

136 stars 52 forks source link

Problem event update or delete multiple effected rows #31

Closed wiseguysby closed 3 years ago

wiseguysby commented 3 years ago

I've a problem.

Sorry for my bad english

When I was testing with one row update/delete, event trigger worked properly, but when with multiple rows update/delete, event trigger only running for couple rows not all, for example UPDATE employee SET emp_status = 'N' WHERE emp_id = 1 --> working well. UPDATE employee SET emp_status ='N' --> not working well, event trigger not fired for all rows, only couple rows (random).

Could you help me for this situation ? Thanks a lot.

wiseguysby commented 3 years ago

I've fixed my code the problem was solved.