Check out example codes for "import Data in MySQL without using any other software". It will help you in understanding the concepts better.

Code Example 1

Convert file in .csv
CREATE TABLE (name of the table you insert data in)(
columns
);

LOAD DATA INFILE "path\\name.csv" INTO TABLE (name of the table you insert data in)
FIELDS TERMINATED BY "fields terminated by"
LINES TERMINATED BY "lines terminated by"
IGNORE (how many lines to ignore) LINES
(columns)

Learn ReactJs, React Native from akashmittal.com