Collections:
UPDATEXML() - Updating Child Element in XML
How to update a child element in an XML document at a given location using the UPDATEXML() function?
✍: FYIcenter.com
UPDATEXML(xml, path, subxml) is a MySQL built-in function that updates a child element in an XML document at a given location. For example:
SET @xml = 'XY'; SELECT UPDATEXML(@xml, '/a', 'Z '); +-----------------------------------+ | UPDATEXML(@xml, '/a', 'Z ') | +-----------------------------------+ |Z | +-----------------------------------+ SELECT UPDATEXML(@xml, '//b', 'Z '); +------------------------------------+ | UPDATEXML(@xml, '//b', 'Z ') | +------------------------------------+ | XY | +------------------------------------+ SELECT UPDATEXML(@xml, '//b[2]', 'Z '); +---------------------------------------+ | UPDATEXML(@xml, '//b[2]', 'Z ') | +---------------------------------------+ | XZ | +---------------------------------------+
Note that variables used in the location path must be escaped with the '$' prefix. For example,
SET @i =1; SELECT UPDATEXML(@xml, '//b[$@i]', 'Z '); +-----------------------------------------+ | UPDATEXML(@xml, '//b[$@i]', 'Z ') | +-----------------------------------------+ |Z Y | +-----------------------------------------+
Reference information of the UPDATEXML() function:
UPDATEXML(xml, path, subxml): newxml Updates a child element in an XML document at a given location. Arguments, return value and availability: xml: Required. The XML document to be updated. path: Required. The location path where the existing element is updated. subxml: Required. The XML element to replace with. newxml: Return value. The updated XML document. Available since MySQL 4.0.
⇒ VALUES() - Column Value for "ON DUPLICATE KEY UPDATE"
⇐ SLEEP() - Holding Statement Execution
2023-12-19, 250🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...