Preventing automatic updates with a trigger


show more Preventing automatic updates with a trigger provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training show less
please wait ...

Preventing automatic updates with a trigger

Triggers may also be used to prevent changes to rows that have already been reconciled or should not be changed for other reasons. In this lesson, I'll be copying and pasting from the Chapter Seven exercise files. Keep in mind that I still have the customer table from the previous lesson, so if you haven't followed along you can create it from the exercise file. Going to be using the scratch database and I'm going to switch over here to the exercise file for Chapter 7 and scroll down to movie 02, preventing automatic updates.

And I'm just going to copy and paste everything from here. All the way down to there. But first let's just take a look at it. I'm going to drop the widget sale table and recreate it. And the reason I'm recreating it, is because I want to add this reconciled flag. And you notice that I'm inserting some rows into the table and as I insert those rows, I'm setting that flag just on the middle one, on. Item number two and I'm setting that flag on...

Preventing automatic updates with a trigger
Video duration: 7m 29s 4h 24m Beginner

Viewers:

Preventing automatic updates with a trigger provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training

Subject:
Developer
Software:
MySQL
Author:
please wait ...