Вопрос по mysql, sql, xml – MySQL для обновления атрибута XML

2

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

UPDATE biblioitems
SET marcxml = UpdateXML(marcxml,'datafield[@tag="520"]/subfield[@code="3"]',
                     'datafield[@tag="520"][@ind1="3"]/subfield[@code="a"]')
WHERE biblionumber = '220405';

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

<datafield tag="300" ind1=" " ind2=" ">
  <subfield code="f">article</subfield>
</datafield>
<datafield tag="520" ind1=" " ind2=" ">
  <subfield code="3">A description of something here</subfield>
</datafield>
<datafield tag="655" ind1=" " ind2=" ">
  <subfield code="a"></subfield>
</datafield>

Error: User Rate Limit Exceeded

<datafield tag="300" ind1=" " ind2=" ">
  <subfield code="f">article</subfield>
</datafield>
<datafield tag="520" ind1="3" ind2=" ">
  <subfield code="a">A description of something here</subfield>
</datafield>
<datafield tag="655" ind1=" " ind2=" ">
  <subfield code="a"></subfield>
</datafield>

Error: User Rate Limit Exceeded

Ваш Ответ

3   ответа
0

SET marcxml = UpdateXML(marcxml,'datafield[@tag="520"]/subfield[@code="3"]/@code', 'code="a"') WHERE biblionumber = '220405';

Error: User Rate Limit Exceededselect updateXML('<x a="aaa" b="bbb">xxxxxx<c>cccc</c></x>', 'x/@a', 'a="aaa" d="ddd"')

2

attribute::att

SELECT UpdateXML('<root><sub att="foo" xatt="bar">Content Text</sub><sec att="etc">Container</sec></root>', '/root/sub/attribute::att', 'att="something"')

<root><sub att="something" xatt="bar">Content Text</sub><sec att="etc">Container</sec></root>

Error: User Rate Limit Exceeded'root/sub/@att'Error: User Rate Limit Exceeded
2

Error: User Rate Limit ExceededUpdateXMLError: User Rate Limit Exceeded

Error: User Rate Limit ExceededExtractValue:

UPDATE biblioitems
SET    marcxml = UpdateXML(marcxml,
         'datafield[@tag="520"]',
         CONCAT(
           '<datafield tag="520" ind1="a" ind2="',
              ExtractValue(marcxml, 'datafield[@tag="520"]/attribute::ind2'),
           '">',
           '  <subfield code="a">',
             ExtractValue(marcxml, 'datafield[@tag="520"]/subfield'),
           '  </subfield>',
           '</datafield>'
         )
       )
WHERE  biblionumber = 220405;

Error: User Rate Limit ExceededError: User Rate Limit Exceeded.

Error: User Rate Limit Exceeded Ashimema
Error: User Rate Limit ExceededUPDATE biblioitems_temp SET marcxml = UpdateXML(marcxml, '//datafield[@tag="520"]', CONCAT( '<datafield tag="520" ind1="3" ind2=" ">', ' <subfield code="a">', Extractvalue(marcxml, '//datafield[@tag="520"]/subfield[@code="3"]'), ' </subfield>', '</datafield>' ) ) WHERE Extractvalue(marcxml, '//datafield[@tag="520"]/subfield[@code="3"]') !=''; Ashimema

Похожие вопросы