0

I'm getting the values in my stored procedure as below in mysql.

(task_id,equipment_name,equipment_hours) 12,'jcb,tractor,bike','10,12,15'

Here i need to split the comma separated values and need to insert them in the table as below in my stored procedure (Please note that the number of values is not fixed).

ID  Equipment_name  Equipment_hours
12  jcb              10
12  tractor          12
12  bike             15

How i can achieve this in mysql stored procedure.

Bill Karwin
  • 538,548
  • 86
  • 673
  • 828

0 Answers0