/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 vote283 views1 answer
How to drop columns with constraint from a table in sql script
SQL
4 votes291 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote296 views1 answer
Sql last 7 days
SQL
6 votes333 views2 answers
Sql sequence
SQL
0 vote255 views1 answer
Mysqli or pdo
SQL
0 vote302 views1 answer
Soql user profile
SQL
0 vote305 views2 answers
Sql searching via key word
SQL
0 vote331 views1 answer
Postgres foreign key multiple columns
SQL
2 votes282 views1 answer
Mysql auto increment jumping
SQL
0 vote385 views1 answer
Stop and start mysql
SQL