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

0 vote119 views1 answer
Mysql a from on this page has
SQL
1 vote123 views2 answers
Maximum number of tables in mysql
SQL
0 vote161 views1 answer
Sql server datetime
SQL
0 vote121 views1 answer
How to save data in database in mysql node
SQL
5 votes130 views1 answer
Oracle add time to date
SQL
0 vote143 views1 answer
Migrations.RunSQL
SQL
3 votes122 views1 answer
Sql server check version
SQL
4 votes74 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
11 votes122 views2 answers
Having clause in sql
SQL
0 vote113 views1 answer
Check if record exists mysql
SQL