Interacting with databases

Let's suppose that your company requires an application that can interact with databases to insert, update, and display data in a user-friendly way. Currently, you have only learned how to connect and view data in Node.js. To insert, update, and display data, first, you will need to understand how Node.js handles queries that change data and outputs through the browser.

In Chapter 5, Correlating Data Across Tables, you were introduced to Node.js and learned how to set it up with libraries and some basic functionality. This chapter picks up where you left off and will teach you how to work with data that is present in the MySQL server using Node.js. As you work through this chapter, you will learn how to implement some particularly useful SQL queries, such as insert and update, which will allow you to work with data and Node.js. These methods will allow you to insert and update data within a database. In addition to this, you will learn how blocking...