PHPMyAdmin - Create Table in PHPMyAdmin
From Krystal Hosting Wiki - UK Web Hosting Support
This tutorial is a continuation of our tutorial on creating a database driven web site.
Contents |
Introduction to PHPMyAdmin
PHPMyAdmin is an online utility that comes as standard on all our hosting packages and is accessible from the cPanel homepage. It allows you to manage your databases through a simple user interface. Please see jeux casino
Tutorial Overview
This tutorial shows you how to create a table in a database that has already been created. We will then populate the table with some data. Click here for a tutorial on how to create a database or write my essay.
Step 1 - Open up PHPMyAdmin
PHPMyAdmin can be found on the cPanel landing page:
Step 2 - Find the database that you created
Continuing from the tutorial, I have found my database called "paulAgency". Click on this link.
Step 3 - Add a new table
You will now be asked to create a new table in your database. In my scenario as a letting agency, I am going to create a table that contains details of all the available properties called "properties". For this tutorial, I have created 5 fields, although in reality you would expect a lot more information to be stored about a property!
Step 4 - Create fields in the table
You now need to create fields in the table. In my scenario, I have created 5 fields that relate to a property description. Please note in the screenshot below how I have created a row for the ID of the property - this is important. The "id" row is the attribute has to be a unique number for each property - you should set the "extra" column to "auto_increment" as I have done. This means the ID number will be automatically assigned - you won't need to specify it manually each time.
