Imports CSV data into MySQL and exports it again

import_export_to_csv.sql

-- import
CREATE DATABASE IF NOT EXISTS import_csv;
USE import_csv;
CREATE TABLE IF NOT EXISTS persons (
	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	`firstname` TEXT NOT NULL,
	`lastname` TEXT NOT NULL,
	`age` INT NOT NULL
);
LOAD DATA INFILE 'data.csv' 
	INTO TABLE import_csv.persons 
	FIELDS 
		TERMINATED BY ',' 
		ENCLOSED BY '"' 
		LINES TERMINATED BY '\n' 
		IGNORE 1 ROWS;
    
-- export
SELECT `id`, `firstname`, `lastname`, `age` 
	INTO OUTFILE 'data.csv' 
		FIELDS 
			TERMINATED BY ',' 
			OPTIONALLY ENCLOSED BY '"' 
			ESCAPED BY '\\' 
			LINES TERMINATED BY '\n' 
		FROM persons;