Affiliates
Cat Heros | Puriri Designs | Prodigious | Shadowfire | Simple Nite | Nixi | In Depth | Apply?

Creating a Table Tutorial

This is the continuation of the first tutorial which is creating your database. After creating your database, please follow this tutorial to learn how to create a table inside it ^-^

What you need

In this tutorial, I'm going to use PHPmyAdmin which is available in most hosts including Dreamhost. Also, your host needs to support PHP and MySQL.

Setting Up Your Table

Click PHPmyAdmin (it's beside your hostname on Dreamhost). Once you've clicked it, login. You will see something similar to this:



See the drop down list on the left nav? Select it and click on your database.

Adding the code

After reaching to the database, click SQL and paste this code:

CREATE TABLE name ( );

Hold on! This won't do anything!
Explanation
Create the table is the command to create the table inside the database, name is the name of the table.

CREATE TABLE name ( date date NOT NULL, );

This code will create the database with a date that you can insert.

For more help, visit our other tutorials!