Node.js program for storing data in a MySQL database

In this post, I am going to show an example of a Node.js program to store the data in a MySQL database.

To store data in MySQL using Node.js, you’ll need to follow these steps:

1. Set Up a MySQL Database: If you haven’t already, you need to have MySQL installed on your system. You should also create a database and a table where you want to store your data. You can use tools like phpMyAdmin or command-line utilities to do this.
2. Install Required Node.js Packages: You’ll need to install the mysql package, which is a MySQL driver for Node.js. You can install it using npm (Node Package Manager):
   • npm install mysql

     1	npm install mysql

3. Create a Node.js Application: Now, create a Node.js application where you can interact with the MySQL database.
4. Initialize the MySQL Connection: You need to establish a connection to the MySQL database using your credentials. Here’s an example:
   • JavaScript

     const mysql = require('mysql'); const connection = mysql.createConnection({ host: 'localhost', user: 'your_username', password: 'your_password', database: 'your_database_name' }); connection.connect((err) => { if (err) { console.error('Error connecting to MySQL: ' + err.stack); return; } console.log('Connected to MySQL as id ' + connection.threadId); });

     1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

     const mysql = require('mysql');   const connection = mysql.createConnection({   host: 'localhost',   user: 'your_username',   password: 'your_password',   database: 'your_database_name' });   connection.connect((err) => {   if (err) {     console.error('Error connecting to MySQL: ' + err.stack);     return;   }   console.log('Connected to MySQL as id ' + connection.threadId); });

     
      
5. Insert Data into the MySQL Database: To insert data into the database, you can use SQL queries. Here’s an example of how to insert data:
   • JavaScript

     const newData = { name: 'John', email: 'john@example.com' }; const insertQuery = 'INSERT INTO your_table_name SET ?'; connection.query(insertQuery, newData, (err, results) => { if (err) throw err; console.log('Inserted new data with ID:', results.insertId); });

     1 2 3 4 5 6 7 8

     const newData = { name: 'John', email: 'john@example.com' };   const insertQuery = 'INSERT INTO your_table_name SET ?';   connection.query(insertQuery, newData, (err, results) => {   if (err) throw err;   console.log('Inserted new data with ID:', results.insertId); });

6. Retrieve Data from the MySQL Database: To retrieve data, you can use SQL SELECT queries. Here’s an example:
   • JavaScript

     const selectQuery = 'SELECT * FROM your_table_name'; connection.query(selectQuery, (err, results) => { if (err) throw err; console.log('Retrieved data:', results); });

     1 2 3 4 5 6

     const selectQuery = 'SELECT * FROM your_table_name';   connection.query(selectQuery, (err, results) => {   if (err) throw err;   console.log('Retrieved data:', results); });

7. Close the MySQL Connection:
   • JavaScript

     connection.end((err) => { if (err) { console.error('Error closing the connection: ' + err.stack); return; } console.log('Connection closed.'); });

     1 2 3 4 5 6 7

     connection.end((err) => {   if (err) {     console.error('Error closing the connection: ' + err.stack);     return;   }   console.log('Connection closed.'); });

Replace placeholders like your_username, your_password, your_database_name, your_table_name, and the data you want to insert with your actual information. This is a simple example of showing how to insert and retrieve data in a MySQL database and tables. Additionally, you may want to use asynchronous methods or a connection pool for better performance in a production environment.