In this article, I will demonstrate how to establish a connection with SQL and perform various CRUD operations in a few simple and easy steps. I will be using phpMyAdmin as MySQL database.

Prerequisites

• Install the latest LTS version of Node.JS from https://nodejs.org/en/download/
• Install the latest version of Visual Studio 2019 from https://visualstudio.microsoft.com/downloads/
• Prior experience in the usage of MongoDB with NodeJS.

Why phpMyAdmin as a database?

phpMyAdmin has a very good UI/UX where we can easily create a new database, new table, insert multiple values to columns at a time, can change and add a primary /foreign key, export/import complete database, etc with few clicks.
In order to run phpMyAdmin server, we need to download XAMPP. …