/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

18 votes287 views6 answers
Laravel form validation
SQL
1 vote288 views1 answer
PL SQL MODIFY COLUMN NME
SQL
4 votes276 views1 answer
Wilayah indonesia sql
SQL
1 vote288 views2 answers
Last working day in week date function in sql
SQL
1 vote289 views1 answer
Drush sql-dump
SQL
1 vote291 views1 answer
Sql alchemy with azuresql server
SQL
0 vote272 views1 answer
Mysql trim characters
SQL
0 vote278 views1 answer
Truncate a table then insert data
SQL
8 votes287 views1 answer
Alter tablespace add datafile autoextend
SQL
1 vote274 views2 answers
Sql convert datetime to year month
SQL