mysql 解析XML做为多数据行

例如

输入：i_devXML 设备ID集合，XML格式
                <Grid>
                  <Data id='device'>
                    <Row><device_id>XXX1</device_id>
                    </Row>
                    <Row><device_id>XXX4</device_id>
                    </Row>
                  </Data>
                </Grid>

==========

。。。

    SELECT EXTRACTVALUE(i_devXML,"count(Grid/Data[@id='device']/Row)")  INTO int_devc_cn;#行数

。。。

    WHILE int_i <= int_devc_cnt DO
          SELECT EXTRACTVALUE(i_devXML,CONCAT("Grid/Data[@id='device']/Row[",int_i,']/device_id'))
           INTO int_device_id
               ;

     END WHILE;