Summary
In this chapter, we covered a lot of information and learned many new skills, as well as about views, stored procedures, functions, and triggers. You learned how to create views and how to determine which views are updatable and which are read-only, and why. You also learned how to create and use functions. Finally, you learned how to create stored procedures to perform some pretty amazing tricks while using the INOUT
parameters before learning about the good, the bad, and the ugly of triggers.
In the next chapter, we will start applying MySQL queries to web applications through Node.js. This will allow you to develop a dynamic application using data from MySQL databases.