How to split columns and add to mysql table from csv

Asked Jan 31 '16 at 08:50

Active Jan 31 '16 at 11:28

Viewed 156 times

I have csv file Studies contains

RollNo, subject1, subject2, subject3

Now I want to create table Study in Mysql contains column:

RollNo Subject

Eg.- csv file has entry

15CS1001, NLP, IR, ML

and corresponding entries in table would be

15CS1001 NLP
15CS1001 IR
15CS1001 ML

stackoverflow shows how to insert selected columns from csv file to mysql, but it insert whole column.

edited May 23 '17 at 11:59

Community

asked Jan 31 '16 at 08:50

piyush-balwani

1

You should consider doing the spliting in your application end and then insert the data to your table. – Rahul Jan 31 '16 at 09:03
1

But if you do dump it into a temporary table then SELECT a,b UNION SELECT a, c UNION SELECT a, d will help – Strawberry Jan 31 '16 at 11:31
@Strawberry this query returns only result of first SELECT a,b – piyush-balwani Jan 31 '16 at 20:59
@Strawberry the result return by SELECT, is it possible to store it in table. – piyush-balwani Jan 31 '16 at 21:05

0 Answers0