Sams Teach Yourself PHP, MySQL® and Apache All in One, Fifth Edition

Chapter 17. Using Transactions and Stored Procedures in MySQL

In this chapter, you learn the following:

• 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

In the preceding chapter, you learned the basics of SQL and how to use the MySQL command-line interface to issue queries and retrieve the results. Armed with only 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, you might require more advanced tactics to maintain the integrity of your data and enhance your application’s ...