Introduction to Transactions3:14 with Andrew Chalkley
When seeding or populating a database for the first time, you will have lots of data to add. But what happens when there's an error in the middle of that process?
Autocommit - every statement you write gets saved to disk.
Seeding - populating a database for the first time.
Script file - a file containing SQL statements.
Switch autocommit off and begin a transaction:
To save all results of the statements after the start of the transaction to disk:
See all of the SQL used in Modifying Data With SQL in the Modifying Data With SQL Cheatsheet.
You need to sign up for Treehouse in order to download course files.Sign up