How to import some columns of csv file to mysql phpmyadmin

Asked Sep 17 '19 at 17:09

Active Sep 18 '19 at 04:56

Viewed 50 times

I have read this but I don't know where is the file.csv located, that has been targeted in answer.

I have a csv file having 5Gb of size,meaning a lot data, I want to import some of the columns from that csv file into my live database (phpmyadmin).

Note

The csv file from where I want to import some columns is on my local computer, and I want to import about 10 columns among 30 columns.

How can I do that, please help me, thanks ?

edited Sep 18 '19 at 04:56

asked Sep 17 '19 at 17:09

contributor

what should I write instead of `'/tmp/mydata.txt'`, as I have question about that ! – contributor Sep 17 '19 at 17:19
`LOAD DATA LOCAL INFILE `/tmp/mydata.txt` , should I write the same ? also I want to import some of the columns , how can I do that ? @HimanshuAhuja – contributor Sep 17 '19 at 17:23
1

You mean to say you dont know where the file is located yes write the same – Himanshu Sep 17 '19 at 17:24
the file is located on my `local` computer, I want to upload it to the `live` database – contributor Sep 17 '19 at 17:25
@HimanshuAhuja , that didn't solved my problem as that is different than mine, – contributor Sep 18 '19 at 06:14

How to import some columns of csv file to mysql phpmyadmin

0 Answers0