MySQL 8 Cookbook

How to do it...

Earlier, you have saved first_name and last_name to a file. You can use the same file to load the data into another table. Before loading, you should create the table. If the table already exists, you can directly load. The columns of the table should match the fields of the file.

Create a table to hold the data:

mysql> CREATE TABLE employee_names (       `first_name` varchar(14) NOT NULL,       `last_name` varchar(16) NOT NULL       ) ENGINE=InnoDB;Query OK, 0 rows affected (0.07 sec)

Make sure that the file is present:

shell> sudo ls -lhtr /var/lib/mysql/employees/result.csv-rw-rw-rw- 1 mysql mysql 180 Jun 10 14:53 /var/lib/mysql/employees/result.csv

Load the data using the LOAD DATA INFILE statement:

mysql> LOAD DATA INFILE 'result.csv' ...