Mysql load data infile csv

LOAD DATA LOCAL INFILE 'abc.csv' INTO TABLE abc
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(col1, col2, col3, col4, col5...);

Source: stackoverflow.com

Similar codes

11 votes378 views1 answer
Oracle export view ddl
SQL
11 votes368 views2 answers
How to import mysql database command line
SQL
0 vote367 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
2 votes355 views2 answers
Sqlalchemy filter or
SQL
0 vote342 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote335 views1 answer
Select count postgres double row count > 1
SQL
1 vote375 views2 answers
Mysql limit offset
SQL
0 vote334 views1 answer
Sql datediff month
SQL
0 vote334 views1 answer
Contact mysql column field
SQL
0 vote322 views1 answer
Mysql begin statement
SQL