在mysql数据库中有一段xml字符串,如下:
set @qq='
<root>
<seq id="1">
<state>0</state>
<score></score>
</seq>
<seq id="2">
<state>0</state>
<score>98</score>
</seq>
</root>';
现在我想在root节点下添加一个seq子节点,使之变为
<root>
<seq id="1">
<state>0</state>
<score></score>
</seq>
<seq id="2">
<state>0</state>
<score>98</score>
</seq>
<seq id="3">
<state>0</state>
<score>98</score>
</seq>
</root>';
如何处理?谢谢!
set @qq='
<root>
<seq id="1">
<state>0</state>
<score></score>
</seq>
<seq id="2">
<state>0</state>
<score>98</score>
</seq>
</root>';
现在我想在root节点下添加一个seq子节点,使之变为
<root>
<seq id="1">
<state>0</state>
<score></score>
</seq>
<seq id="2">
<state>0</state>
<score>98</score>
</seq>
<seq id="3">
<state>0</state>
<score>98</score>
</seq>
</root>';
如何处理?谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货