×
×

Start creating your website now!

We launch our best shared hosting offers.
Create your success and find the latest deals on web hosting, transfers and dedicated servers.
Use this promotional code
JHTZP6BS3NO at checkout to receive the discount.

Creating a database table

Back

Before you can do anything with your Database, you should create a table and set the corresponding fields in it.

Creating a table in PHPMyAdmin is simple. Just type the name, select the number of fields and click the Go button. You will then be taken to a setup screen where you should create the fields for the database.

database.jpg



Alternatively, you can run a MySQL query, which will create the table. The format is:

CREATE TABLE tablename (

Fields

)


The fields are defined as follows:

fieldname type(length) extra info,


The fields are separated by comma.

For example, if you wish to create a table called Members with 3 fields in it - FirstName, LastName and Age, you should execute the following query:

CREATE TABLE Members
(
FirstName varchar(15),
LastName varchar(15),
Age int
);


More information on how to connect to the database and how to query it can be found in the following tutorials:

  • Connect to the database
  • Query the database
  • Display table data
  • Select individual records


Powered by HostBill