Using the CSV storage engine to export data

MySQL supports multiple storage engines. The default storage engine is InnoDB, but there are a few more shipped with the server. There are also third-party storage engines available, an example of which is the MyRocks storage engine from Facebook, which allows MySQL to use RocksDB to store data. The job of a storage engine is to store and retrieve data, while the server knows how to parse and execute SQL queries. The CSV storage engine that comes with MySQL allows you to store data in a CSV file and query it via SQL. This can be used to export and import data. The server knows how to copy or move data from one storage engine to another, so this also works for data that is stored in any other storage engine. The main limitation of this is that you require direct access to the filesystem of the server.

You can also make your tables use a particular storage engine. Consider the following code where you modify your languages table to use the...