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

8 votes75 views1 answer
Oracle current date plus 1 month
SQL
0 vote128 views1 answer
Postgres list all triggers
SQL
0 vote106 views1 answer
Sql where time stamp is in between
SQL
3 votes129 views1 answer
Oracle sql commit example
SQL
3 votes120 views1 answer
Unsigned int in mysql
SQL
0 vote183 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote105 views1 answer
Psql datestyle
SQL
0 vote102 views1 answer
Mysql group rows with same value
SQL
15 votes113 views4 answers
Mysql where value is null
SQL
0 vote115 views1 answer
Top 3 salary in sql
SQL