How do I insert data in to a table in my MySQL database?

This article applies to 123 Reg Shared Hosting and 123 Reg Premium Hosting packages.

Once you have created a table you will need to populate it with some information, this can be done from your webpage or manually in phpMyAdmin.

Step 1 of 8

Start by logging in to your Control Panel and scroll down to ‘Web Hosting’. From there, select Manage.

General Control Panel

 

Step 2 of 8

On the next page, select Manage for the account you wish to use.

General-Manage Sites

 

Step 3 of 8

Select the three-dot icon for the package you want to edit. From there, choose Settings from the drop-down menu that appears.

Choose Settings

 

Step 4 of 8

On your dashboard, select phpMyAdmin.

Select phpMyAdmin

 

Step 5 of 8

Select the database you wish to access from the left-hand menu.
Select Database

 

Step 6 of 8

Find the table you wish to add data to and click Insert.

Click Insert

 

Step 7 of 8

Enter the information and then click Go to add it.

Enter your information

 

Step 8 of 8

You’ll then receive confirmation that this has been saved.

The following steps apply to Web Hosting plans purchased before July 2020 and Premium Hosting plans purchased before August 2020:

Step 1 of 6

Click on the MySQL Database link in the Web Tools section of your hosting control panel.

 

Step 2 of 6

In the Manage Databases section press the Manage button to access phpMyAdmin.

 

Step 3 of 6

If you have a blank database, click on the database name in the left hand frame.

 

Step 4 of 6

Select the Table you will be adding data to and click on the Insert tab.

 

Step 5 of 6

Enter the information, and then click on the Go button.

 

Step 6 of 6

You will then see the SQL code for inserting the data.

The Data has been added to the table.