[SQL] Trigger to track Update, Insert, Delete
I have not seen a tutorial yet on this topic. Hopefully this video will be helpful in the grand archives of the internet.
The trigger made in this tutorial is to track updates, inserts, and deletes. We'll save the old and new values, preserving them in an audit table. In the next video, we will create a View in SQL that will better organize the information in the audit table. Keep an eye out for part 2!
🔴 IF YOU WANT THE CODE: 🔴
Go to our GitHub at https://github.com/VeeBeeCoding/YouTu....
The file name will match the YouTube title name for the corresponding video.
🔗 Other Links
Instagram - / veebeecoding
Ko-fi - https://ko-fi.com/veebeecoding
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
🖐Hi! I'm VeeBee, you can call me VB or Bee for short! Over the years during my career I have been keeping a journal of what I have learned when working in different languages and projects.
🏁 My goal is to pass along what I have learned to you by teaching through projects and exercises based on real world experiences.
✨ My promise to you is that I will do my best to not waste time. Each video will have a full summary at the very beginning so that you can determine if you can skip the video if you already know the material, or the summary can be a refresher if you're coming back.
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
☕ If you found this tutorial helpful and would like to spot me a coffee as thanks, please consider leaving a small tip or donation on my Ko-Fi site at https://ko-fi.com/veebeecoding.
Tips are never expected, but always appreciated! I plan on creating content regardless, so there is no pressure or obligation to donate.