Join Bill Weinman for an in-depth discussion in this video Preventing automatic updates with a trigger, part of MySQL Essential Training (2014).
…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 that…one and its not going to be set on the others.…
- 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.