Mysql insert from local 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

-1 vote149 views1 answer
How to Activate the database
SQL
0 vote155 views1 answer
Sql create and grant user access to database
SQL
0 vote117 views1 answer
Primary key multiple colums
SQL
0 vote123 views1 answer
Oracle sql developer closed connection
SQL
4 votes116 views1 answer
Oracle error line
SQL
0 vote115 views1 answer
Sql row number in result set
SQL
1 vote124 views1 answer
Postgresql round double precision
SQL
1 vote129 views1 answer
Date in where on datetime column clause mysql
SQL
14 votes113 views3 answers
How to add default constraint in mysql
SQL
1 vote116 views1 answer
Drop df constraint sql server
SQL