MySQL Triggers

In this tutorial, I will teach you MySQL Triggers

👉 GRAB MY COURSE 👈
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Do you want to become a web developer from scratch?

I have spent 4 months creating the BEST course that exists about web development and in this course I am teaching everything that you need to know to become a web developer from scratch.

It's helped hundreds of students, it can help you too.

👉 ABOUT VIDEO 👈
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
It is MySQL Tutorial For Beginners.

A SQL trigger is a set of SQL statements stored in the database catalog. A SQL trigger is executed or fired whenever an event that is associated with a table occurs.

We set triggers for INSERT, UPDATE, DELETE MySQL Command. Each command can have BEFORE and AFTER triggers.

In this tutorial, I will teach you How To Create MySQL Triggers.

👉 LETS CONNECT 👈
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

[TheMegaEzio]

This tutorial is in its own league, great job!!

[mgedier]

You're the one who finally helped me with my trigger in MySQL. You can't imagine how much time I wasted watching tons of pages and videos with no result at all. Thank you very much!!!

[bradleymosher]

Skipped class where we learned about triggers. This was hugely helpful.

[anthonyikediashi]

Nice video man...please I will like to know how u can use triggers to know time of table update and also how to prevent anyone from updating your table.

[shwedaz]

What do You think, is it proper way to use trigger if I want to change product_quantity field from other database? Actually I need to change MySQL product_quantity from MSSQL product_quantity..

[MathematicalCowboy]

You explained it way better than professor did! You're awesome!!!!

[deshario]

Is it possible to use triggers in same table after update ...
ex : there are 3 fields [required, paid, status]
in users table
I nees to compare paid field with required field after update in line 11 and 12 and if both are equals then update status field ... How to do it ?

Good tutorial, but please drop the music next time. The recording of your voice is already resounding in your room and the music gives me a hard time understanding what you are saying (plus the same loop over and over again starts to be annoying after a few times). No hard feelings though.

[AtulMadawi]

Very easy to undertand explanation of MySQL Triggers.. Thanks Senaid..

[abusufiankayal]

Thanks, Sir it really helped me understand the triggers.Thank you very much

[tiwale]

Hi, can you talk a bit about recursive triggers?

[marfans]

Excellent video, please create more!!

[gcpdev]

Good demo Kevin. Helped me at my work. Cheers !

[wiktorliszkiewicz]

Yep triggers make it so damn easy to create history tables.
Ps. That was very clean explanation. Thanks for sharing.

[fuenf.]

WOW! Best triggger tutorial I found. Thank you very much you helped me a lot!

[EshanNilanka]

Can anyone please tell me what is the error of below given code?

DELIMITER $$
create trigger after_videor_update
after INSERT on video_ratings
for each row
begin
declare updatecount integer(10);
updatecount = select count(RATINGS) AS BAD_TOTAL from video_ratings where RATINGS='0');
update video_upload
SET RATE_BAD = updatecount
where USER_ID = NEW.STU_ID AND ID = NEW.VID_ID
END$$
DELIMITER ;

[_devParty]

Very good tutorial. Lovely style of rendering. Simply brilliant

[khalidskiod]

nice tuto thank you i just understand triggers in mysql <3

[algerienoranais]

This is a very nice tutorial, Really well explained. Thank you

[ahmedaboelnaga]

how can i register every user who insert or update in mysql workbench