How do I insert data in to a table in my MySQL database?
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:
Step 1 of 9
Login to your 123 Reg control panel
Step 2 of 9
Scroll down to the Web hosting section.
Step 3 of 9
Select the relevant domain name from the drop down box and click on the Manage button.
Step 4 of 9
Click on the MySQL Database link in the Web Tools section of your hosting control panel.
Step 5 of 9
In the Manage Databases section press the Manage button to access phpMyAdmin.
Step 6 of 9
If you have a blank database, click on the database name in the left hand frame.
Step 7 of 9
Select the Table you will be adding data to and click on the Insert tab.
Step 8 of 9
Enter the information, and then click on the Go button.
Step 9 of 9
You will then see the SQL code for inserting the data.
The Data has been added to the table.