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.