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 and filtering JSON documents
- Using JSON functions and operators to query JSON data
- Using generated columns to query and index JSON data
- Activity 13.01 – exporting report data to...
