Triggers | SQL | Tutorial 20

[@samupatrick64]

I just joined today and based on how I am seeing the tutorials and mode of lectures from you, I know I will soon become a database admin. Thanks in advance

[@tonnysocrates9741]

Still following Giraffe academy, best instructor in the world

[@nickfeldman2996]

Thank you for the help, whenever I'm trying to teach myself how to program, you've always been a HUGE help. So thank you thank you thank you!!!

[@michelef406]

The only thing greater than your teaching skills is the amount of "actually" used in this video

[@mritunjay7065]

Finally, I successfully created triggers with no errors ! Thank you Sir.

[@jj0511]

Just took a Udemy course in triggers were part of it. Had no idea really the rhyme or reason behind it on a grander scale, just new basic syntax of it but you clarified everything and even expanded my knowledge on the syntax so thank you so much

[@jacktheflasher]

Thank you! KZbin needs more teachers like you!

[@L_iebestraum]

And suddenly it all looks way easier than my professor's explaination. You have my thanks! And my sub.

[@LuciaSilva-ek3qr]

Finally, I understood the usage of delimiters in triggers statements. Thank you!

[@jenanabualrub2915]

loved the pam beesly part

[@maclo4]

Best tutorial ive seen. Delimeters make way more sense now

[@objectivelyobjective]

Very good one a tutor 👍🏾👍🏾👍🏾

[@garyrobinson8991]

Wonderful pace of the content ! Well done !

[@titalobe4727]

You are great Mike

[@eduardodiaz215]

about time for Kevin t make his appearance!

[@leonholz5901]

great explanation with an example, perfect!

[@rozzydozzyknives]

The office names ftw

[@RoleJohn]

indeed.12 minutes were enough . thanks keep it up

[@titalobe4727]

Your great Mike

[@prashanthr2092]

You are great❤️

[@lessonsfromlifethroughthes5917]

Really great video...

[@mini_rajnikant3616]

love you bro, keep it up

[@aje9633]

this is really helpful to create logs.

[@sarrab7087]

you ar the best teacher ever thank u for the perfect explanation

[@reinaldofanuel5892]

Your videos really Helpful.

[@faizalimuhammadzoda4731]

Really helpful. Thanks.

[@aqsayousaf6587]

keep it up..it is really very helpful

[@daniilpogolovkin8221]

Thanks !

[@shaliniverma2223]

thanku u sir great concept

[@richarddetsch7912]

Good review. May have wanted to use an ALTER TRIGGER functionality at 8:26

[@teeahtate]

Very good. Thanks

[@alhassanabdulaziz5121]

very educative and i real enjoy it

[@absurd7292]

Respect sir

[@rachitanayak_]

yasss really helpful.. thanks man!!!!

[@SetYourHandle3]

it really was helpful. Thank you dude :)

[@priyaverma7976]

Why so less subscribers here, you deserve alott sir

[@parteystephenson814]

thanks sir!

[@seetsamolapo5600]

Hey Mike please do sth on AWS and Azure from the ground up

[@tiara4tiara]

Thank you !

[@kaboom8431]

can triggers be used to create a log table(custom log to note particular changes), where we can see changes attempted with date&time or is there simple method to check log

[@SteveoStories]

It gives me error 1064 when trying to change the delimeter

[@sergegoita189]

Great Job :) Thank you!

[@HumblebeeRules]

I don't really get the NEW.blabla, why is it there?

[@javierfuertes487]

I guess what NEW does in this case is that it brings the new name being inserted. Under my limited knowledge, I can imagine that if you write old (when updating a table) it'll bring you the old name before its changed

[@lepystudio8974]

nice tutorial

[@gurukalyanvarra3287]

🙏🙏🙏 bro keep doing

[@reedofwater]

Video begins at 2:57.

[@bunmi4164]

Still having trouble creating trigger

[@alanzhu7538]

Awesome video. One quick question tho, how can you show all triggers that have been created?

[@chenyang2879]

I’m assuming you already found the answer since it’s been 9 months

[@zedhacking]

Hi Mike ! Thank you for this tutorial .... i m just using microsof sql serveur in this tutorial and was fine ... but in this lessoon i cant find command line for microsoft sql and i can"t access to it with cmd (sqlcmd -E -I ..... this command its not working) if you know how to do that or anyone else knows ... please let me know and help me , and thank you again

[@Ahmadkz]

Kevin from accountant

[@christopherrahme780]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMETER $$ CREATE TRIGGER my_trigger BEFORE INSERT ON employee FOR EACH ROW BE' at line 1

[@christopherrahme780]

Ok. I am so dumb. I was trying triggers at 9 am while working with WampServer and MySQL 5 Got that error Couldn't understand why Searched for this video I don't have PopSQL and the database I decided to download PopSQL and MySQL 8 and watch all the videos Now it's 6:30 pm And I finally realize that my mistake was that I was typing "delimiter" incorrectly all along

[@cashmeoutsidehowboutthat9275]

Christopher Rahmé happens

[@danielchristianto306]

DO YOU SPEAK INDONESIAN?

[@Lesa1408]

ERROR 1465 (HY000): Triggers can not be created on system tables

[@weizhang8954]

me neither

[@reinaldofanuel5892]

DELIMITER ## CREATE TRIGGER TGR AFTER INSERT table_Name BEGIN DROP TGR; END## DELIMITER ; LOL

[@ivanovski.stojan]

Thank you!