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

This article applies to our Web Hosting and 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.

Simply click on a title below to skip to the most appropriate FAQ. You can also click the Top button to return and make another selection.

Web Hosting plans purchased after July 2020 / Premium Hosting plans purchased after August 2020 (cPanel)

Step 1 of 6

Start by accessing your Web Hosting dashboard.


Step 2 of 6

On your dashboard, select phpMyAdmin.

Select phpMyAdmin


Step 3 of 6

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


Step 4 of 6

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

Click Insert


Step 5 of 6

Enter the information and then click Go to add it.

Enter your information


Step 6 of 6

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

Web Hosting plans purchased before July 2020 / Premium Hosting plans purchased before August 2020

Step 1 of 10

Start by logging in to your legacy Control Panel. For details on how to do this, please read the following article: How do I access and manage my products?

Step 2 of 10

From there, select Web Hosting or Premium Hosting within the ‘Manage active products’ section, depending on which product you wish to use.

Next, select Manage opposite the ‘(bought before XX/XX/XX)’ option.

Manage Shared Web Hosting


Step 3 of 10

This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.

Manage Legacy hosting


Step 4 of 10

On the next page, select Manage for the domain you wish to update.

Manage hosting domain


Step 5 of 10

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


Step 6 of 10

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


Step 7 of 10

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


Step 8 of 10

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


Step 9 of 10

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


Step 10 of 10

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

The Data has been added to the table.