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. To do this in phpMyAdmin, please do the following:

1

Login to your 123-reg control panel

2

Scroll down to the Web hosting section.

3

Select the relevant domain name from the drop down box and click on the Manage button.

 Web_hosting_section.jpg
4

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

5

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

6

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

7

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

8

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

9

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

The Data has been added to the table.