How do I create a new table in my MySQL database?
Website software such as WordPress or Joomla that are used to create features such as blogs, forums and content management systems will automatically create the required tables for the function in your database. If your needs require you to additional tables, please do the following:
Step 1 of 11
Login to your 123 Reg control panel
Step 2 of 11
Scroll down to the Web hosting section.
Step 3 of 11
Select the relevant domain name from the drop down box and click on the Manage button.
Step 4 of 11
Click on the MySQL Database link in the Web Tools section of your hosting control panel.
Step 5 of 11
In the Manage Databases section press the Manage button to access phpMyAdmin.
Step 6 of 11
If you have a blank database, click on the database name in the left hand frame.
Step 7 of 11
Type in the Name of the new table and how many fields you want to have (this can be changed later).
Step 8 of 11
Then click the Go button.
Step 9 of 11
You will next be asked to enter the settings for the Table. Enter your settings then click on the Save button.
Step 10 of 11
You will get a confirmation that will show the SQL code that was used to create the table.
Step 11 of 11
An overview of the Table will be shown, also any additional information that is relevant to the table.