mysql 解析xml串

<bookstore>
  <book>
    <title>Learning XML</title>
    <author>Erik T. Ray</author>
    <year>2003</year>
  </book>
  <book>
    <title>Learning Java</title>
    <author>James Gosling</author>
    <year>1995</year>
  </book>
</bookstore>

DELIMITER //

CREATE PROCEDURE InsertBooks(IN xmlString TEXT)
BEGIN
  DECLARE title VARCHAR(255);
  DECLARE author VARCHAR(255);
  DECLARE year INT;
  DECLARE done INT DEFAULT FALSE;

  -- 声明游标
  DECLARE cur CURSOR FOR
    SELECT 
      XML_EXTRACT(xmlString, '/bookstore/book/title'),
      XML_EXTRACT(xmlString, '/bookstore/book/author'),
      XML_EXTRACT(xmlString, '/bookstore/book/year')
    FROM 
      (SELECT @xmlString := xmlString) AS t;

  -- 声明继续处理的条件
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

  OPEN cur;

  read_loop: LOOP
    FETCH cur INTO title, author, year;
    IF done THEN
      LEAVE read_loop;
    END IF;

    INSERT INTO books (title, author, year) VALUES (title, author, year);
  END LOOP;

  CLOSE cur;
END //

DELIMITER ;

CALL InsertBooks('<bookstore>...</bookstore>');