User Tools

Site Tools


developmental:mysql:phpmyadmin-table-create

How to Create a MySQL Table in PhpMyAdmin

Most applications need databases to properly work, and although for the most part we do not need to modify these databases, we do need to create, delete, backup and restore databases from time to time.

In this article we are going to review how to create tables in phpMyAdmin. Since this process is very simple, we are going to show you a few screenshots of how to accomplish this.

If you are using cPanel, you can access phpMyAdmin directly from cPanel.

Once we have logged into phpMyAdmin, on the left top side of the screen we are going to see existing databases. First, click on the desired database:

Once you click on the desired database, the "Create Table" form will be under the list of tables.1) Before the table will be created, we will need to:

  1. Type in the name of the table
  2. Type in the "Number of columns/fields" the table is going to contain
  3. Click Go

Once we have clicked on "Go" we are going to see a screen asking for several fields. For the simplest tables, we can focus on the first 3 fields:

  1. Name of the column
  2. Type of characterset, for example INT for integers, or VARCHAR for regular text
  3. The maximum length these fields can store in characters.

As an example, here is how my table looks:

Once the above is done, we can click save and that is it, you have a new table:

1)
if there are any existing tables. If this is a new database without tables, the Create Table form will be the only thing in the main section of the page.
developmental/mysql/phpmyadmin-table-create.txt · Last modified: 2018/02/02 14:43 by Marjorie S.