In MySQL, I am converting a table from a single row per item type (a quantity of items) to a single row per item, so that additional detail can be stored about individual items.

Here is an example source table:

```
id    parent_id    qty    item_type
--    ---------    ---    ---------
1     10291        2      widget
2     10292        4      thinger

```

I want to create a new table with a new column containing info that cannot be applied to more than one item. Thus, the above table would end up as follows:

```
id    parent_id    item_type    info
--    ---------    ---------    ----
1     10291        widget       [NULL]
2     10291        widget       [NULL]
3     10292        thinger      [NULL]
4     10292        thinger      [NULL]
5     10292        thinger      [NULL]
6     10292        thinger      [NULL]

```

Is there a way I can iterate or loop each row of the source table, inserting a number of records equal to the source `qty` column? I would prefer to do this in sql instead of code to keep all of the conversion steps together (there are many others).