Node.js MySQL

Node.js MySQL is one of the external libraries of Node.js. It helps Node.js developers to connect to MySQL database and execute MySQL Queries.

We shall learn to install MySQL module in Node.js using npm, and use SQL statements with clearly illustrated examples.

Node.js MySQL

Following is quick view of topics we are going to learn about Node.js MySQL

Node.js MySQL

 

Install MySQL in Node.js

As Node.js MySQL is an external module, it can be installed using NPM (Node Package Manager).

Run the following command in terminal or command prompt to install MySQL module and use it in Node.js programs.

After successful install, you may use MySQL module in node.js programs by declaring its usage with a require statement as shown below.

Note – If MySQL module is not installed, but used in Node.js programs, you might get the Error : Cannot find module ‘mysql’.

 

Create Connection to MySQL Database

To create a connection variable with IP Address (of server where MySQL server is running), User Name and Password (of user that has access the MySQL database). An example is provided below :

 

SELECT FROM Query

MySQL SELECT Query is used to select some of the records (with some of their properties if required) of a table.

 

Conclusion :

In this Node.js Tutorial, we have learnt to install MySQL module/package in Node.js using npm.