Free collection of beautiful vector icons for your web pages.

Lesson 5.2. phpMyAdmin

Graphical interface

One of the keys to MySQL's success is its graphical interface phpMyAdmin which allows you to

This interface is developed in PHP and can easily be installed on a server. MySQL and phpMyAdmin are generally installed by default on most hosting or development environments.

MySQL queries are written in SQL which is a command line language that may seem austere at first. For a first use of MySQL, we are going to use phpMyAdmin. The latter displays the MySQL queries for each action performed in the graphical interface.

If you do not have a phpMyAdmin installation on your server or your local machine, you can perform the exercises on the interface demo of phpMyAdmin at this address: [ Please note, the databases are cleaned (erased) frequently and the privileges of users are reset. Out of courtesy to others users, do not modify the content of databases that do not belong to you.

Create database

In the interface of phpMyAdmin, create a new database:

Database creation in phpMyAdmin

The interface informs you that your database is empty (no table) and you suggests creating your first table.

Create your first table

In your database, create a stocks table that contains 4 columns. On the next page, define the fields of each column:

Create a new table in phpMyAdmin

Save and check the table:

New table stored in phpMyAdmin

Insert data

The table is created and ready to use.

Add a few lines into the table and observe the syntax of the SQL queries. Always leave the id field empty, it will automatically complete when creating a new row.

Table with rows in phpMyAdmin

See also

Last update : 02/03/2020