Chapter 17. Using Transactions and Stored Procedures in MySQL

In the previous chapter, you learned the basics of SQL and how to use the MySQL command-line interface to issue queries and retrieve the results. Armed only with that knowledge, you can successfully complete the projects found in the remaining chapters of this book. However, when you move forward with your knowledge and think about building applications suitable for use in an enterprise environment, more advanced tactics may be needed to maintain the integrity of your data and enhance your application's communication with MySQL.

Although the remaining chapters in this book will not contain elements from this chapter, you can easily update the code on your own to include the information you learn in this chapter. In this chapter you will learn

• The basics of transactions and how to use them in MySQL

• The basics of stored procedures and how to create and access them in MySQL