Learn SQL Database Programming

Importing CSV files with table data import

Using the database (schema) and the tables you created in the last chapter, we will add data to those tables via table data import. I named that schema yourschema, so the directions will reflect that naming convention. Swap out that name for whatever name you called your database. We will be using the GitHub CSV files that are referenced in the Technical requirements section of this chapter. Follow these steps:

1. Open MySQL Workbench.
2. Connect to your local or dev/test instance where you created your database in the last chapter.
3. Open the database you created in the previous chapter (yourschema, in the following example) by clicking the down arrow.
4. Open Tables by clicking the down arrow.
5. Right-click ...