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

0 vote111 views2 answers
Athena drop partition
SQL
0 vote109 views1 answer
Sql get table last modified time
SQL
0 vote107 views1 answer
Mysql select smaller of two values
SQL
0 vote95 views1 answer
Sql server whoami
SQL
8 votes115 views3 answers
SQL column name
SQL
0 vote108 views1 answer
How to print some string in mysql
SQL
0 vote101 views1 answer
How to reset table in sql server
SQL
-1 vote100 views8 answers
Create Trigger in phpMyAdmin
SQL
1 vote180 views1 answer
How to select the nth row in a SQL database table?
SQL
2 votes97 views1 answer
Match in sql server
SQL