In the seventh class of the phpMyAdmin course we see the triggers, which is neither more nor less than detecting when an action is being performed.
Databases normally use the SQL language, this language has simple statements to access, update, delete and add information.
However, although many people are unaware of it, it also has advanced queries, which together with the engine (MySQL, MariaDB…) make the databases really powerful.
One of those options are the “triggers” or “triggers” that consist of detecting when an action is being performed (UPDATE/INSERT/DELETE) and performing a certain action.
But said like that, it can be a bit complex to understand AND to do! But thanks to phpMyAdmin this is very easy. Let’s see how we can do it!
Now that we have seen the video, we can understand the enormous potential that triggers have, in fact, they are so powerful that we could save many hours of programming (if we are programmers).
Imagine a program that every night has to check some data in the database (purchases, etc.) and depending on that data, make some updates to the database (billing table). Thanks to the triggers we can do it in real time. And the best thing is that we would not have to program any code.
As always, if you have any doubt or question, you can send it through the support form of the subscriber intranet. See you in the next lesson! 🙂
Remember that if you will have access to everybody the courses and you can also enjoy everything from .
Facebook Comments
Disqus