/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 vote194 views1 answer
Mysql wsrep ls
SQL
0 vote218 views1 answer
Get the next column of a table in mysql
SQL
0 vote204 views1 answer
For row in sql database python loop
SQL
0 vote201 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote227 views1 answer
Psql create usr
SQL
7 votes196 views4 answers
What is my mysql version
SQL
0 vote233 views1 answer
Wordpress make wp user in db
SQL
0 vote196 views1 answer
UNION ALL LEFT JOIN
SQL
14 votes208 views1 answer
Excel
SQL
2 votes196 views1 answer
Postgresql drop primary key constraint
SQL