Here, you will register test data in your database.
At this moment, there is no data registered in the database you created earlier.
To practice data selection, registration, deletion, etc. with SQL, please register test data first.
Download SQL test data from the link below.
The downloaded zip file is compressed. So, unzip it with an unzipping tool and you will get an SQL file “techfun_en.sql”.
techfun_en.sql is the SQL file to create test data. Use it to register test data in the database.
Click the URL below to open a database management screen.
The “phpMyAdmin” screen will be displayed. phpMyAdmin is the tool to operate MySQL from a web browser.
You will find the list of databases on the left part of the displayed screen. Select the database to use from the list.
Select “techfun” or the database you created.
If you see the message “Import has been successfully finished. XX queries ・・” on screen, it means import is completed.
Note that the number of queries shown in the message may vary depending on each sql file’s version but you do not have to care about it.
mysql > show tables;
If several table names are displayed, test data registration is successfully complete.
That’s all for Test Data Creation.