Creating a table in a database with phpMyAdmin



Creating a table in a database with phpMyAdmin

This video assumes you've already logged in to phpMyAdmin.

Now let's learn how to create a table within a database.

First, select the database in which you want to create a table.

Enter a name for the table.

Enter the number of fields this table is to have, then click Go.

Next, enter the details for each field including a name and field type.

Let's make this first field the Primary Key, and we'll click here to make it Auto_Increment.

The remaining fields will be character fields. Be sure the length is set long enough to accomodate the field values.

When finished, click Save.

That's it! Our new table has been created within our database.

This is the end of the tutorial. You now know how to create database tables with phpMyAdmin.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Becoming familiar with databases and phpMyAdmin

Becoming familiar with databases and phpMyAdminThis video assumes you've already logged...

Copying a database table with phpMyAdmin

Copying a database table with phpMyAdminThis video assumes you've already logged in to...

Deleting a table from a database with phpMyAdmin

Deleting a table from a database with phpMyAdminThis video assumes you've already...

Deleting fields from database tables with phpMyAdmin

Deleting fields from database tables with phpMyAdminThis video assumes you've already...

Exporting databases and tables with phpMyAdmin

Exporting databases and tables with phpMyAdminThis video assumes you've already logged...

Powered by WHMCompleteSolution