Chapter 13: Getting Data into MySQL
In this chapter, we will cover different ways to get data into MySQL and export it from inside the MySQL server to various formats. We will begin with adding data to tables and collections, and then move on to exporting data from MySQL to CSV files, and importing data from CSV, SQL, and JSON files. By the end of this chapter, you will be able to utilize the CSV storage engine to export and import data.
This chapter will cover the following topics:
- An introduction to data preparation
- Working with the X DevAPI
- Inserting documents
- Loading data from a SQL file
- Loading data from a CSV file
- Loading data from a JSON file
- Using the CSV storage engine to export data
- Using the CSV storage engine to import data
- Searching ...
Get The MySQL Workshop now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
