In this video, Chuckk walks us through how to use triggers with Vultr Managed Databases for MySQL. Triggers are database objects associated with a table, and will be activated when a defined action is executed for the table.
Chuckk shows us how to store changes into the database so that they can be accessed and manipulated. These triggers won't work on read operations but they will allow you to do any set of actions whenever a row of data is changed or deleted.
🔗 Links
Become a Vultr Creatr = https://vultr.com/creatr
Vultr Managed Databases = https://vultr.com/products/managed-da...
Vultr Twitter = / vultr
Vultr Docs = https://vultr.com/docs
Vultr Marketplace = https://vultr.com/marketplace
Chapters
00:00 Intro
01:02 Explanation of tutorial03:38 Video walkthrough
05:32 Keep track of new records
08:27 Create table09:15 Data type of the fields
12:54 Run before the insert trigger begins
13:10 Bind to action
16:40 Double @@ signs to end statement
19:00 Insert a record
23:45 return the current datetime
27:54 Outro
Смотрите видео Vultr Tutorial: Bind Actions to Events with MySQL Triggers онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Vultr 04 Август 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 363 раз и оно понравилось 6 людям.