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

This article applies to 123-reg Linux Shared Hosting accounts.

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.

Answer options

Your feedback was successfully added.

Answer tracking

Track

Watch the content of this article for changes.