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




Sams Teach Yourself PHP, MySQL And Apache All in One
Sams Teach Yourself PHP, MySQL and Apache All in One (3rd Edition)
ISBN: 0672328739
EAN: 2147483647
Year: 2004
Pages: 327

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net