Need help with SQL loop/insert

Discussion in 'MySQL' started by Rahul Bose, Jul 8, 2010.

  1. #1
    Hello,
    I have a table that has data in this format:

    code | code ext | description
    1199 | 0 | job code bullet 1 description
    1199 | 0 | job code bullet 2 decription
    1199 | 0 | job code bullet 3 description
    1199 | 1 | job code bullet 1 description
    1199 | 1 | job code bullet 2 description
    1200 | 0 | job code bullet 1 description
    1200 | 0 | job code bullet 2 description

    The table contains job data. Each code can have multiple extensions. I need to figure out how to loop through this data, and add an auto increment count for each unique job code and extension and then reset, continue on and continue counting. So for example here is the new format I need of the above data:

    code | code ext | description | count
    1199 | 0 | job code bullet 1 description | 1
    1199 | 0 | job code bullet 2 decription | 2
    1199 | 0 | job code bullet 3 description | 3
    1199 | 1 | job code bullet 1 description | 1
    1199 | 1 | job code bullet 2 description | 2
    1200 | 0 | job code bullet 1 description | 1
    1200 | 0 | job code bullet 2 description | 2

    Basically I need a bullet number count for each entry of a unique job code and extension. So since 1199-0 had 3 entries, it auto counts those 3. Then it sees that unique job code and ext is done, sees 1199-1 and starts the count of bullet items etc.

    Can anyone help?
     
    Rahul Bose, Jul 8, 2010 IP