asked on
Create multiple records in MySQL table based on value of one field.
I am looking to create multiple records based on a single value in a field in MySQL.
I have some data that looks like this in a table in MySQL
item_id | grade
12345 | 01
12346 | 05
12347 | 09-12
I need to transform it into something that looks like this:
12345 | 01
12346 | 05
12347 | 09
12347 | 10
12347 | 11
12347 | 12
Where 09-12 is can be a range of values
09-10
11-12
06-08
etc.
I have some data that looks like this in a table in MySQL
item_id | grade
12345 | 01
12346 | 05
12347 | 09-12
I need to transform it into something that looks like this:
12345 | 01
12346 | 05
12347 | 09
12347 | 10
12347 | 11
12347 | 12
Where 09-12 is can be a range of values
09-10
11-12
06-08
etc.
MySQL Server
Last Comment
theGhost_k8
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks all, I'm still working on implanting these suggestions.
Author is requested to choose the best solution. Otherwise the points will be equally split between the two of the commenters offering solution.