I have table :
id | name
1 | a,b,c
2 | b
in another table i want like this :
id | parent | name
1 | 1 | a
2 | 1 | b
3 | 1 | c
4 | 2 | b
Please help me how to get it done in MySQL
Asked
Active
Viewed 390 times
0
Punit
- 405
- 5
- 14
-
First of all, you need to splt that string. see here: http://stackoverflow.com/questions/5928599/equivalent-of-explode-to-work-with-strings-in-mysql – vaso123 Jun 03 '16 at 14:25
-
So do you want to insert first table's data into second table ? – AsgarAli Jun 03 '16 at 14:25
-
yes @AliKhanusiya i want to insert in 2nd table – Punit Jun 03 '16 at 14:53
-
Is it Ok if I will provide solution using PHP + MySQL ? – AsgarAli Jun 03 '16 at 15:05
-
maybe interesting? http://stackoverflow.com/a/37230297/3184785 - generate rows from a delimited string. – Ryan Vincent Jun 03 '16 at 15:09
-
Hopefully this endeavor is to correct and never use again CSV data in a column. Lord let's hope so. – Drew Jun 04 '16 at 04:42
-
@AliKhanusiya no, actually i know how to do it with PHP, but i need it by MySQL, i think Stored Procedure will help in this – Punit Jun 04 '16 at 06:52