Okay so i know insert is to create a new record and update to modify a existing one however for this problem i want to know wouldn't before update make more sense however the question doesn't state current employee. Can you please explain in more simpler terms when to use before insert and update?

Hi wahab! Thanks for reaching out. Whether you will use a before-insert or a before-update trigger depends entirely on what you want to use the trigger in question for. In this particular example, we've used a before-insert trigger just as an example. Hope this helps. Best, Martin

Follow this topic

wahab sultan

Last answered:

24 Oct 2021

Posted on:

16 Oct 2021

Confusion between insert and update?

in SQL / MySQL Triggers

1 answers ( 0 marked as helpful)

Martin Ganchev

Posted on:

24 Oct 2021

Confusion between insert and update?

Submit an answer

related questions