Dharmesh Sharma

Dharmesh Sharma

  • NA
  • 905
  • 928.3k

How to get id one by one

Oct 7 2011 7:50 AM

Hello,


i dont understand how i do that


i have one table in this table has id ,industry id uniq and industry has like "IT,DESIGN,SCO"

now i want to like that im get one by one id and sepret the industry without comma and insert into new table one by one like

1-----IT

1----DESIGN

1---SCO


so how to do this in sql plz help me


Answers (4)