/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 vote311 views10 answers
Delete Query in SQL Server
SQL
0 vote385 views1 answer
What is initial catalog in sql connection string
SQL
1 vote368 views1 answer
Quit mysql
SQL
0 vote360 views1 answer
How to reset table in sql server
SQL
0 vote353 views1 answer
Qt qsql check if table exist
SQL
-1 vote338 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote298 views1 answer
Get last run query sql server
SQL
0 vote410 views2 answers
Clauses in mysql
SQL
0 vote359 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote365 views1 answer
Column ' ' in field list is ambiguous
SQL