Example on how to load a CSV into a MySQL table

README.md

#How to load a CSV into MySQL

This example uses the assumption that I have a table called verse whose schema is

describe verse;
+------------+---------------+------+-----+---------+-------+
| Field      | Type          | Null | Key | Default | Extra |
+------------+---------------+------+-----+---------+-------+
| book_id    | int(11)       | NO   | PRI | NULL    |       |
| chapter    | int(11)       | NO   | PRI | NULL    |       |
| verse      | int(11)       | NO   | PRI | NULL    |       |
| text       | varchar(1000) | NO   |     | NULL    |       |
+------------+---------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

load.sql

LOAD DATA LOCAL INFILE 'FILENAME.csv' INTO TABLE verse
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
(book, chapter, verse, text)