/SQL/Import Data in MySQL without using any other software

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\\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)

Source: youtube.com

Similar codes

1 vote174 views1 answer
Sql comment header
SQL
0 vote194 views1 answer
Mysql order by rand limit 1 really slow
SQL
7 votes172 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote184 views1 answer
Sql #region
SQL
0 vote152 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote189 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote181 views2 answers
Get all index postgres
SQL
6 votes187 views1 answer
Oracle list primary key
SQL
2 votes193 views1 answer
Show max_allowed_packet mysql
SQL
1 vote188 views1 answer
Get parameter value in mysql trigger
SQL