How to create a table in a database in phpmyadmin


 How to create a table in a database in phpmyadmin

This tutorial is going to teach you how to create a table in a database with phpMyAdmin. We are going to assume you are already logged in to phpMyAdmin, and are on the main screen. For the purpose of this tutorial, we are going to create a table in a database that has no tables at this time.

Let’s start by selecting the database in the blue section of the phpMyAdmin setup 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. In the phpMyAdmin setup 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 MySQL Query. In the blue window, the table will now be listed under the database. This is the end of the tutorial. You now know how to create a table within a database using phpMyAdmin setup.

How to copy a database table in phpmyadmin

Advertisements

6 thoughts on “How to create a table in a database in phpmyadmin

  1. Pingback: How to become familiar with databases and phpmyadmin | DMM

  2. Pingback: How to import databases and tables using phpmyadmin | DMM

  3. Pingback: How to insert fields into database tables using phpmyadmin | DMM

  4. Pingback: How to modify fields in database tables using phpmyadmin | DMM

  5. Pingback: How to run SQL Queries on a database using phpmyadmin | DMM

  6. Pingback: check backlinks with pagerank

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s