SQL

import Data in MySQL without using any other software

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

LOAD DATA INFILE "path
ame.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)

Import in mysql without a software

LOAD DATA INFILE "name.csv" INTO TABLE "TableName"
FIELDS TERMINATED BY "sign"
LINES TERMINATED BY "sign"
IGNORE 1 LINES
(columns);