• Your Cart is Empty
  • Cart
  • Log In

How to create a MySQL table

How to create a MySQL table - overview

Let's follow the steps in detail:

1. The first step is to log into your personal web hosting control panel.To do this, click the Control Panel login link in the upper right corner of your screen. Then enter your web hosting account details (this will be your username and password), and click the 'Login' button to go straight to your Control Panel.

2. The second step is to enter the MySQL Databases section of the Control panel. Once on the Control Panel index page you need to click the 'MySQL Databases' icon under Site Management.

3. To create a MySQL table you need to open the phpMyAdmin tool for the coresponding database.

3.1. Once in the MySQL Databases section click the database name link or its corresponding phpMyAdmin icon to open the phpMyAdmin tool.

3.2. Then select the database from the drop-down list on the left. Next step is to define the new table's name in the 'Name' field of the 'Create new table on database' form. Then specify the number of fields in the table in 'Number of fields' and hit the 'GO' button.

3.3. Once the new table is created you can specify the fields' names, length, collation, attributes, etc. In our tutorial movie we've specified some examplary field name and values for the 3 fields we created in the previous step.

3.4. Once you specify the values for Length, select the Collation type from the drop-down menu you need to hit the 'Save' button to save you new table settings.

Then you'll can see a summary of all MySQL database table settings.

You are all done with the MySQL database table creation steps.