Bug #13728 add XML parsing like MSSQLServer does
Submitted: 4 Oct 2005 0:38 Modified: 29 Oct 2009 12:28
Reporter: Anatoliy Savchak Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[4 Oct 2005 0:38] Anatoliy Savchak
It's good to use somth like this:
CERATE PROCEDURE spUpdateMyRows(RowsXML varchar(1000))
  DECLARE ixml;
  CALL xml=xml_prepare(RowsXML);
  CREATE TEMPORARY TABLE T(status char(1), name varchar(45), comments varchar(250));
  INSERT INTO T(name, comments)
    FROM open_xml(ixml, 'dataset/row', 2)
      WITH (status char(1) '@STATUS', name varchar(45) '@NAME', comments varchar(45) '@COMMENTS');

  INSERT INTO MyTable(name, comments) 
  SELECT name, comments
  FROM T WHERE Status = 'I'
  UPDATE MyTable My
    set comments = t.comments
  FROM T WHERE Status = 'U' and My.Name = T.Name;

  DELETE MyTable My
  FROM T WHERE Status = 'U' and My.Name = T.Name;


How to repeat:
[21 Oct 2005 18:19] David L Lambert
During Winter Semester 2005 I attended a class where one group of students implemented C code to parse XML and store it in MySQL tables.  I'm not sure whether they implemented it as an external program,  as user-defined functions,  or as a modification to the MySQL source-code,  but I did see it in operation.  One of the students was David Post;  I believe his e-mail address is ae4933@wayne.edu.
[29 Sep 2009 12:28] Valeriy Kravchuk
Thank you for the feature request. Please, check if XML functions of MySQL 5.1 are enough to implement a kind of processing you need. Check http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html for the details.
[30 Oct 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".