…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…because we have multiple statements here in our trigger.…
- Writing queries
- Creating and updating databases and tables
- Using MySQL built-in functions
- Sorting and filtering data
- Updating tables with triggers
- Working with subselects and views
- Creating and using a stored function
Skill Level Beginner
1. Installing and Configuring the Test Environment
2. Basic Syntax
3. Creating a Database
4. MySQL Data Types
5. MySQL Functions
8. Subselects and Views
9. Stored Routines
10. PHP's PDO Interface with MySQL
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.