Summary
In this chapter, you learned how to insert records into tables and documents into collections. You also imported files in the SQL, CSV, and JSON formats into the MySQL server and combined data from tables and collections. You then used the CSV storage engine to easily import and export data in the CSV format. With the CSV format, it is easy to exchange data with other applications and spreadsheets.
In the next chapter, we will continue with querying data using MySQL. This includes using some more advanced reporting capabilities such as aggregating data and using functions. We will also continue to see what MySQL can do with JSON data.