Web Hosting in India Domain Registration India Mumbai Delhi Bangalore Chennai Chandigarh Pune Hyderabad Kolkata Jaipur Lucknow Ranchi Raipur Bhopal Kanpur Bhubaneshwar Kochi Truvantpuram Ranchi Patna Raipur Ajmer Jodhpur Jabalpur Agra Meerut Noida Ghaziabad

Creating tables in a database with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin

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

Select thedemo1234_members database here



Enter a Name for our new table



Then enter the number of fields this new table is to have. Click Go



Now enter the details of each field within the new table



We also want this first field to be the Primary key that will be automatically filled in (auto_increment) when new entries are added to the table

The first field will be called id, and it will be an integer that's 4 characters in length



Selecting this option makes the id field the Primary key in the table



The remaining fields will be CHAR (character) fields. Be sure the length is set long enough to accomodate the fields



When finished, click Save



That's it! Our new table (details) has been successfully created within our database(demo1234_members) as indicated here



This is the end of the tutorial. You now know how to create new tables within a database using phpMyAdmin

Was this answer helpful?

 Print this Article

Also Read

Exporting databases and tables with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin Now let's learn how to export a...

Searching through a database with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin Now let's learn how to use the...

Becoming familiar with databases in phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin Now let's familiarize ourselves...

Renaming database tables with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin Now let's learn how to rename...

Importing databases and tables with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin Now let's learn how to import a...