Chapter 5

1. Table Data Import and Export, SQL Data Import and Export, Result Data Export, and SQL syntax.
2. Right-click a table, then choose Table Data Import Wizard.
3. You use the Configure Import Settings page to map the columns.
4. Right-click a table and choose Table Data Export Wizard.
5. Go into the Management or Administration panel in MySQL Workbench, then select Data Import/Restore.
6. Go into the Management or Administration panel in MySQL Workbench, then select Data Export.
7. Select rows from a table, then click the Export recordset to an external file button.
8. LOAD DATA INFILE '/pathtoyourfiles/baseballdatabank-csv/csv-files/Teams.csv'
   INTO TABLE yourschema.teams
   FIELDS TERMINATED BY ',';
9. SELECT * INTO OUTFILE 'teams-export.csv'
   FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
   LINES TERMINATED BY '\n'
   FROM yourschema...