/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

0 vote176 views1 answer
Synapse sql table set pk
SQL
0 vote184 views1 answer
Get statis values sql
SQL
0 vote169 views1 answer
Windows services sql
SQL
0 vote121 views1 answer
Get last run query sql server
SQL
1 vote175 views1 answer
Sql to mongodb query converter
SQL
1 vote170 views1 answer
Mysql count multiple columns in one query
SQL
0 vote139 views2 answers
Delete the last item in a table sql
SQL
0 vote188 views1 answer
Sort by
SQL
0 vote172 views1 answer
Sauvegarde complète my sql
SQL
0 vote181 views1 answer
Is not sql
SQL