/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 vote218 views1 answer
Where not in array sql
SQL
0 vote196 views1 answer
What does the -p flag do in mysql cli
SQL
1 vote189 views1 answer
Mysqli connect
SQL
1 vote203 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
1 vote213 views1 answer
Sql view where tables have same column name combine results
SQL
-1 vote204 views1 answer
Sql add column bit
SQL
8 votes206 views1 answer
Script to add datafile to tablespace
SQL
3 votes201 views2 answers
Mysql time
SQL
0 vote219 views1 answer
Mysql bash execute sql file
SQL
1 vote195 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL