title: How to add a node to xml value in MySql
body: <p>My sample xml value looks like</p>
  
  <pre><code>    &lt;food&gt;
       &lt;name&gt;Belgian Waffles&lt;/name&gt;
       &lt;price&gt;$5.95&lt;/price&gt;
       &lt;description&gt;
       Two of our famous Belgian Waffles with plenty of real maple syrup
       &lt;/description&gt;
       &lt;calories&gt;650&lt;/calories&gt;
      &lt;/food&gt;
  </code></pre>
  
  <p>I need to add this <code>&lt;Shop&gt;KFC&lt;/Shop&gt;</code> into the food tag and my output should looks as</p>
  
  <pre><code>  &lt;food&gt;
      &lt;name&gt;Belgian Waffles&lt;/name&gt;
      &lt;price&gt;$5.95&lt;/price&gt;
      &lt;description&gt;
      Two of our famous Belgian Waffles with plenty of real maple syrup
      &lt;/description&gt;
      &lt;calories&gt;650&lt;/calories&gt;
      &lt;Shop&gt;KFC&lt;/Shop&gt;
    &lt;/food&gt;
  </code></pre>
  
  <p>I tried UpdateXml but behaves differently. Is it possible with the available xml functions
  in MySql to do this ?</p>
  
  <p>I am new to MySql. Please help me in figure out this.. 
  Thanks in advance..</p>
  
  <p><strong>UPDATE :</strong></p>
  
  <p>I tried this code </p>
  
  <pre><code>select UpdateXML('&lt;food&gt;
   &lt;name&gt;Belgian Waffles&lt;/name&gt;
   &lt;price&gt;$5.95&lt;/price&gt;
   &lt;description&gt;
   Two of our famous Belgian Waffles with plenty of real maple syrup
   &lt;/description&gt;
   &lt;calories&gt;650&lt;/calories&gt;
  &lt;/food&gt;', '/food/Shop', '&lt;Shop&gt;KFC&lt;/Shop&gt;');
  </code></pre>
  
  <p>and in the second parameter i tried instead <code>'/food/Shop'</code> only with <code>'/food'</code>
  but its not giving the expected results</p>