Ex. 2.5 Import Data
docx
keyboard_arrow_up
School
Pennsylvania State University *
*We aren’t endorsed by this school
Course
210
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
5
Uploaded by BailiffWrenMaster830
Ex. 2.5 Import data from spreadsheet
Purpose: import data into the movies_basic table MySQL Requirements: movies_basic table from previous exercise
Required Screenshots
1.
Step #12
Total Screenshots: 1
Instructions
The movies_basic table is empty and it needs some data. Since we have some raw data in a spreadsheet already, we are going to use the MySQL workbench’s tools to automatically load the data. 1.
Download the data file from Canvas onto your computer.
2.
Right click
on the movies_basic table, 3.
Click
on the table data import wizard. 4.
In the new window that opens up, click
browse to select the data. 5.
And then click
next. 1
On this screen you have the choice of either inserting the data into an existing table or letting the wizard create a new table based on the data. 6.
Select Use existing table.
7.
Click next. On this next screen the wizard wants to know which column in the source data should go into which column in the table. In this case since the source and destination columns have most of the same names it probably has correctly sorted most of them out. However, if you do need to make adjustments just click on the drop down menu and you can change what data goes where. 2
8.
Make sure the wizard has set the columns correctly.
Look closely at the pairings. num_rating needs to be changed.
You might need to change rating to numrating by using the arrows.
3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
9.
Click Next
10. Click Finish
11. Select all the data from the movies_basic table again. All the data is in the right place and you can see that the ID column was automatically populated since we had the auto increment flag set.
4
12.
Submit a screenshot
. Make sure to include the navigator panel so we can see the database with your name.
----------
5