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

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

This article applies to 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 Manage database option.

 Manage_database.jpg
5

Click on the box shape icon under the Login column for the relevant database.

 Login_database.jpg
6

Enter your database username and password in the relevant boxes.

 phpMyAdmin_login.jpg
7

Select the Database and Table, and then click on the Insert tab.

 Table_insert_tab.jpg
8

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

 Table_data_go.jpg
9

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

 Table_data_confirmed.jpg

The Data has been added to the table.