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.
Start by logging in to your Control Panel and scroll down to ‘Web Hosting’. From there, select Manage.
On the next page, select Manage for the account you wish to use.
Select the three-dot icon for the package you want to edit. From there, choose Settings from the drop-down menu that appears.
On your dashboard, select phpMyAdmin.
Select the database you wish to access from the left-hand menu.
Find the table you wish to add data to and click Insert.
Enter the information and then click Go to add it.
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:
Click on the MySQL Database link in the Web Tools section of your hosting control panel.
In the Manage Databases section press the Manage button to access phpMyAdmin.
If you have a blank database, click on the database name in the left hand frame.
Select the Table you will be adding data to and click on the Insert tab.
Enter the information, and then click on the Go button.
You will then see the SQL code for inserting the data.
The Data has been added to the table.