我试图从xml中提取值.我在xml具有属性时遇到问题.
喜欢以下存储过程
DELIMITER $$
DROP PROCEDURE IF EXISTS `excel`.`insert_items` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_items`()
BEGIN
SET @xml = '
Single Line Text_01
Single Line Text_12341
Single Line Text_21
Single Line Text_31
Single Line Text_41
';
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 |
标签:mysql,xml
来源: https://codeday.me/bug/20191001/1839149.html