Logging Transactions with a Trigger in the MySQL System


show more Logging transactions 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 ...

Logging transactions with a trigger

In this example, I'll show you how to use a trigger to update a transaction log. I'm going to start by copying and pasting from the chapter seven exercise file. We're going to be using the scratch database here. And I'm continuing with the tables that were created earlier in the chapter. If you happen to be following along, you can just create these tables from the. Exercise file and you should be fine. So, I'm going to come down here to, Lesson Number three, logging transactions with a trigger. And we're going to copy everything from here on down to here.

First, I'll take a moment to describe it. We're going to recreate the sale table and in this case we're just doing this to get rid of that reconciled flag that we used in the last movie. And we're going to keep the customer table which already has those three records in it for. Bob and Sally and Fred, and then we're going to create this trigger again. We're using the delimiter, to change the delimiter...

Logging transactions with a trigger
Video duration: 4m 9s 4h 24m Beginner

Viewers:

Logging transactions 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 ...