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

Renaming database tables with phpMyAdmin

Renaming database tables with phpMyAdmin This video assumes you've already logged in to...

Deleting a table from a database with phpMyAdmin

Deleting a table from a database with phpMyAdmin This video assumes you've already logged in to...

Exporting databases and tables with phpMyAdmin

Exporting databases and tables with phpMyAdmin This video assumes you've already logged in to...

Importing databases and tables with phpMyAdmin

Importing databases and tables with phpMyAdmin This video assumes you've already logged in to...

Running SQL queries on a database with phpMyAdmin

Running SQL queries on a database with phpMyAdmin This video assumes you've already logged in to...

Powered by WHMCompleteSolution