Import into csv in MySQL

Question

I have for example csv with a lot of columns and have my DB. I need to import all data from 1 column named oldfile to my database in column symbol. How to make it with sql query?

did you try solving this yourself first? – Funk Forty Niner Dec 06 '16 at 19:23 — Funk Forty Niner, Dec 06 '16 at 19:23

score 0 · Accepted Answer · answered Dec 06 '16 at 19:23

0

Use LOAD DATA INFILE to import from CSV to MySQL databse table. Example:

LOAD DATA INFILE 'data.csv' INTO TABLE my_table;

answered Dec 06 '16 at 19:23

Rahul

76,197
13
71
125

and how can i highlight concrete columns? – Alex Ulianov Dec 06 '16 at 19:26
@AlexUlianov, go through the linked documentation page. That will help you. – Rahul Dec 06 '16 at 19:26

Import into csv in MySQL

1 Answers1