UPDATEXML

Purpose

This function is used to update the content of a node specified by a path in an XML string.

Syntax

UPDATEXML(xml_target, xpath_expr, new_xml)

Parameters

Return type

The return type is LONGTEXT.

Examples

• Use the UPDATEXML function to replace the </a> node in the XML string with the <x>carrot</x> node and return the updated XML string. <a/><b/> represents a root node containing two nodes, <a> and <b>.

  obclient [test_db]> SELECT UPDATEXML('<a/><b/>', '/a', '<x>carrot</x>');
  

  The return result is as follows:

  +----------------------------------------------+
  | UPDATEXML('<a/><b/>', '/a', '<x>carrot</x>') |
  +----------------------------------------------+
  | <x>carrot</x><b></b>                         |
  +----------------------------------------------+
  1 row in set
  

• Use the UPDATEXML function to replace the a node under the root node in the XML string with the <b>bbb</b> node and return the updated XML string.

  obclient [test_db]> SELECT UPDATEXML('<root><a>aaa</a></root>', '/root/a', '<b>bbb</b>');
  

  The return result is as follows:

  +---------------------------------------------------------------+
  | UPDATEXML('<root><a>aaa</a></root>', '/root/a', '<b>bbb</b>') |
  +---------------------------------------------------------------+
  | <root><b>bbb</b></root>                                       |
  +---------------------------------------------------------------+
  1 row in set