/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 vote123 views1 answer
Mysql make date from 2 column
SQL
0 vote119 views1 answer
Mysql sql select one day before
SQL
0 vote101 views1 answer
Oracle list chain steps
SQL
1 vote109 views1 answer
Jooq convert using gbk
SQL
0 vote112 views1 answer
SQL authentication error
SQL
1 vote119 views1 answer
Tsql find foreign key references
SQL
3 votes140 views5 answers
Foreign keys
SQL
79 votes211 views6 answers
Grepper code
SQL
0 vote112 views1 answer
Oracle create package body
SQL
2 votes131 views1 answer
Set auto increment from 1
SQL