How to import .csv file in defined table in command line?

Question

I need to import.csv file throught windows command line terminal in defined table.

I was trying this command :

C:\xampp\mysql\bin\mysql -u root -p dbname dbtablename < C:\xampp\htdocs\site\csvfolder\import.csv

But it does not works. What am I doing wrong ?

Joe · Accepted Answer · 2017-10-15 19:51:30Z

0

I believe you have to use LOAD DATA INFILE for csv files. See here: https://dev.mysql.com/doc/refman/5.7/en/load-data.html.

You can run it from the command line like so:

mysql -u root dbname -p -e "load data infile 'c:/path/to/file.csv' into table dbtablename"

answered Oct 15, 2017 at 18:16

Joe

4663 silver badges7 bronze badges

so there is no terminal solution...need to work in mysql anyway ?
– John
Oct 15, 2017 at 19:23
Try: mysql -u root -p dbname -e "load data infile 'c:/path/to/file.csv' into table dbtablename". I edited my answer to include this.
– Joe
Oct 15, 2017 at 19:50

Add a comment |

Jitendra Patel · Accepted Answer · 2022-12-28 07:27:44Z

0

Please put your CSV file in the same location where you run the command and try again.

(like : c:\xampp\mysql\bin\mysql\import.csv)

c:\xampp\mysql\bin\mysql -u root -p database_name table_name < import.csv

Jitendra Patel

9241 gold badge6 silver badges20 bronze badges

answered Dec 28, 2022 at 6:03

Janmesh Dargode

972 bronze badges

Add a comment |

2 Answers 2