Creating tables in a database with phpMyAdmin

Start by selecting the database in the blue section that needs a table. Click on it. In the right hand window, a panel will open. It is to Create a new table. There is a blank box, and you need to enter a Name for the new table. Then in the next box, enter the number of fields this new table is going to have. When you are ready, click Go.

Now a new set of boxes will open. These are the blank fields for your new table. You need to enter the details of each field within the new table in the first column. In the second column, you select the type of entry, such as interger, or decimal, or text, etc.. The third column is for the length of the entry, or how many characters long. You may also want to select a certain field to be Primary key. That is one that will be automatically filled in (auto_increment) when new entries are added to the table. This is often times an id field, which auto-populates with an id number. To make it Primary key, select the first icon after the Extra box, and mark the radio button. The icon is a page with a key in front of it. Finish entering names and information for the rest of your fields. For example, if you were going to make one field Name, that would be a Char for type (character). And you would want to make sure you left enough length for any name that might be entered, so length might be something like 100. Telephone in the field would again be a Char type, and you would want to make the length about 50. When you are done, click on the Save Button.

The screen will now show you the table you have created, and the SQL Query. In the blue window, the table will now be listed under the database.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Managing MySQL Databases With PHPMyAdmin

On the main cPanel page, scroll down to the section called Databases, and click on the icon named...

How To Create A MySQL Database

On the main cPanel page, scroll down to the Database section, and click on the MySQL Databases...

Importing databases and tables with phpMyAdmin

The phpMyAdmin main screen is broken into two sections. The left hand side is blue, and this is...

Inserting fields into database tables with phpMyAdmin

Let's begin by locating the database name in the blue section on the left of the phpMyAdmin...

Deleting tables in a database with phpMyAdmin

For this tutorial, we will be using a database with two tables for the example. In the left hand...

Powered by WHMCompleteSolution