XAMPP stands for Cross-Platform (X), Apache (A), MySQL (M), PHP (P) and Perl (P). It is a simple, light-weighted Apache server that makes it extremely easy for developers to create a local HTTP server with just a few clicks.
Step 1: Download XAMPP
Download one of the version of XAMPP from the link given below
The installation of XAMPP is very straightforward just like any other application.
To create a new database open a web browser and search for http://localhost/phpmyadmin/, you will find PHPMyAdmin dashboard select databases and create a new database.
Select the database that you created where you will find an option to create table, give the table name and select number of columns that you need for your table and click ok.in the next step give column names with appropriate datatype and size and also you can insert data into a table by selecting the Insert tab.
You can simply run these queries to create a new table and to insert data.
CREATE TABLE Users( UserID int, LastName varchar(255), FirstName varchar(255), Email varchar(255), City varchar(255) );
INSERT INTO Users(UserID , LastName , FirstName , Email , City)