从mysql中的xml提取值 [英] extract value from xml in mysql
本文介绍了从mysql中的xml提取值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试从xml提取值. xml具有属性时出现问题. 就像下面的存储过程一样
i am trying to extract values from xml. i am getting problem when xml has attribute. like following Stored Procedure
DELIMITER $$
DROP PROCEDURE IF EXISTS `excel`.`insert_items` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_items`()
BEGIN
SET @xml = '<items><item>
<value columntype="0">Single Line Text_01</value>
<value columntype="1">Single Line Text_12341</value>
<value columntype="2">Single Line Text_21</value>
<value columntype="3">Single Line Text_31</value>
<value columntype="4">Single Line Text_41</value>
</item>
</items>';
SELECT @columntype, ExtractValue(@xml, 'items/item/value[items/item/value/@columntype=0]');
END $$
DELIMITER ;
推荐答案
获取具有属性columntype="0"
SELECT ExtractValue(@xml, 'items/item/value[@columntype=0]') value;
输出:
| VALUE |
-----------------------
| Single Line Text_01 |
SQLFiddle
这篇关于从mysql中的xml提取值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文