-
Install XAMPP.
-
Open XAMPP Control panel and start Apache Web Server and MySQL Database.
- Extract the folder with the file in
C:\xampp\htdocs
.
-
Open any browser and type
localhost/phpmyadmin
. -
Click on New at side navbar.
-
Give a database name as
FiredUp
and hit on Create button.
-
After creating database name open browser and type localhost/ and your folder name which is located in
C:\xampp\htdocs
, in my casehttp://localhost/FiredDB/
-
Your file will appear on the screen, click on it.
-
Open browser and type
localhost/phpmyadmin
again. -
Click on FiredUp at side navbar and will open a database with four tables.
- You can open any table by clicking on it.
-
- Click on Designer at top database navbar to see relationships between tables.
- To write queries you need click on SQL at top navbar.
- Example of query result output.