MySQL Triggers Tutorials for Beginners #4 - Trigger After Insert & Trigger Before Update

In this video we'll see:
TRIGGER AFTER INSERT & TRIGGER BEFORE UPDATE
SOCIAL :
===============
Subscribe : / onlinewebtutor
FACEBOOK : / owthub
TWITTER: / owthub
BLOG: onlinewebtutor...
UDEMY: www.udemy.com/...
Other Tutorials
===============
Wordpress Customizations:
---------------------------------
Wordpress Theme (Hindi): goo.gl/MZ8maF
Wordpress Widget (Hindi): goo.gl/Dc2htn
Wordpress Plugin (English): goo.gl/BA7dYG
Wordpress Theme Options (English): goo.gl/Vjv3Ub
Wordpress JSON Rest API (English): goo.gl/SVQRQR
Wordpress JSON Rest API (Hindi): goo.gl/NNWfKa
and many more...
Javascript framework:
----------------------------------
Learn backbone.js here! (English) : goo.gl/Qd2Pcs
Learn Vue JS here ! (Hindi): goo.gl/MVtsmh
PHP Frameworks:
----------------------------------
Laravel tutorial (Hindi): goo.gl/Nh9qJk
CakePHP tutorial (Hindi): goo.gl/uRsS3G
Tags
----------------------------------
mysql triggers tutorials,
mysql triggers for beginners tutorial,
step by step mysql trigger tutorial,
beginners tutorial for mysql triggers,
php mysql triggers tutorials,
online web tutor,
online web tutor mysql triggers tutorial,
online web tutor sanjay,
basics of mysql triggers,
complete mysql triggers tutorial,
tutorials for mysql triggers for beginners,
Thanks
Online Web Tutor
Keep learning and Sharing :)

[@vigneshs6045]

thanks a lot bro😁

[@OnlineWebTutor]

Thanks buddy

[@cristobalmaldonado6028]

thanks sir 👍

[@AnishKumar-zc3gj]

Informative..!

[@kajalthakur3480]

Very helpful video sir thanku so much

[@OnlineWebTutor]

Thanks Kajal

[@cheriftouil]

I'm stuck brother, I needt to use create trigger to insert the max values depending on the table group by one columns like id, can you help me with that bro

[@schakkalaka9438]

hello.
i have 2 tables. one with users and one for payments, Payments are in bitcoin.
when the transaction is finished, the value "PAID" on payment table, become "1".
i would like create a trigger, that update the field "IS_PREMIUM" on tbl_users for the user that have pay.
I have do this:
if (new.paid = 1) THEN
update tbl_users SET tbl_users.my_ispremium = 1 WHERE tbl_users.my_deviceid = tbl_users.my_deviceid;
end IF
But it update the "IS_PREMIUM"FIEND FOR ALL USERS. how to fix it?
i use phpmyadmin GUI for create triggers..

[@smaad7]

hi
if on my user table my id is named user_id
do I have to do (new.user_id)

[@mohammedelghazal6077]

thanks bro

[@OnlineWebTutor]

Welcome

[@strongez3357]

братан у тя голос угарный