如何在SQL中读取XML文件？

CREATE TABLE xml_data (
    id INT PRIMARY KEY,
    xml_content XML
);

INSERT INTO xml_data (id, xml_content)
VALUES (1, '<root><name>John</name><age>30</age></root>');

SELECT xml_content.value('(/root/name)[1]', 'VARCHAR(50)') AS name,
       xml_content.value('(/root/age)[1]', 'INT') AS age
FROM xml_data;

UPDATE xml_data
SET xml_content.modify('replace value of (/root/name/text())[1] with "Jane"')
WHERE id = 1;