/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 vote233 views1 answer
Sqlalchemy query join many to many
SQL
2 votes213 views1 answer
Mysql select random id from table
SQL
1 vote235 views2 answers
Remove space in mysql
SQL
0 vote240 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
2 votes238 views2 answers
Enable foreign key checks postgres
SQL
0 vote188 views1 answer
Sql truncate table referencing itself
SQL
0 vote212 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote224 views1 answer
Data types mysql vs postgresql
SQL
0 vote215 views1 answer
Postgresql subquery
SQL
1 vote228 views1 answer
Tsql create unique index composite
SQL