Chapter 6: Stored Procedures and Other Objects
In this chapter, we will continue exploring SQL coding and working with our database. We will create objects that can be reused and flexible enough to accept parameters. By doing this, you will learn how to create views, functions, stored procedures, and transactions to allow users to interact with a MySQL database easily.
This chapter covers the following topics:
- Introduction to database objects
- Exploring various database objects
- Working with views
- Activity 6.01 – updating the data in a view
- Working with user-defined functions
- Working with stored procedures
- Working with IN, OUT, and INOUT
- Exploring triggers
- Using transactions
Introduction to database objects
In the previous chapter, you learned ...
Get The MySQL Workshop now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
