Order Now
Home>Encyclopedia>Video Tutorials>MySQL>How to create a MySQL table
Advanched MySQL Database Management Tools

How to create a MySQL table

Domains and Subdomains Video Tutorials



Our Most Popular Hosting Plans



Budget Hosting

Value Hosting

Plus Hosting

Exclusive Hosting
Budget Hosting - $4.95 per month Value Hosting - $7.95 per month Plus Hosting - $9.95 per month Exclusive Hosting - $14.95 per month
Unlimited Space Unlimited Space Unlimited Space Unlimited Space
Unlimited Traffic Unlimited Traffic Unlimited Traffic Unlimited Traffic
1 Domains Unlimited Domains Unlimited Domains Unlimited Domains
FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *
Order Joomla Web Hosting
Order eLearning Web Hosting
Order WordPress Web Hosting
Order 4images Web Hosting

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.