Use MySQL With NodeJS Application - XAMPP / phpMyAdmin
Hey Guys!
In this tutorial, we are looking at using MySQL with NodeJS and Express. It will help you in learning how to connect to a MySQL database from your Node.js application with practical demonstration. For this, We will build a very basic API to Create, Read, Update and Delete from a MySQL database.
➔ MySQL is an RDBMS (Relational DataBase Management System), PhpMyAdmin is a web application which lets you manage (with a visual interface) MySQL Databases.
➔ XAMPP is a software distribution which provides the Apache web server, MySQL database (actually MariaDB), Php and Perl (as command-line executables and Apache modules) all in one package.
Download XAMPP: https://www.apachefriends.org/downloa...
💻Code: https://github.com/joyal7701/nodemysql
Timestamps
===========
00:00 Intro
00:52 npm init
03:28 Create Connection With MySQL
04:50 Create Database
07:33 Create Table
10:34 Insert Data in Table
13:57 Get Data From Table
15:28 Get Particular Data From Table
17:46 Update Data in Table
20:23 Delete Data From Table
21:53 Outro
► Visit Our Playlists:
/ itbuddies
► LinkedIn: / joyal7701
#mysqlconnection #express