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.
3. To create a MySQL table you need to open the phpMyAdmin tool for the coresponding database.
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.