Nerd For Tech
Published in

Nerd For Tech

MySQL database in phpMyAdmin

Photo by Caspar Camille Rubin on Unsplash
Starting Apache and MySQL modules

Creating a new MySQL database in phpMyAdmin:

Step-1: Open ‘localhost’ on your browser.

Localhost Dashboard
Creating a new database

Creating a new table in the MySQL database:

Step-1: Click on the ‘SQL’ button in the navbar.

Page to run the SQL queries
Create table statement syntax
Creating a table in our database
Syntax for entering values into table
Entering data into a table
Data entered successfully

Running Queries in MySQL:

1. Displaying the whole table using the ‘SELECT’ statement.

‘SELECT‘ statement to display the table
Displaying the table
‘SELECT‘ statement for displaying ‘Name’ column
‘Name’ column displayed



NFT is an Educational Media House. Our mission is to bring the invaluable knowledge and experiences of experts from all over the world to the novice. To know more about us, visit

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store