O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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' ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required