<div dir="auto">Yeah.. I tried and it’s working like charm.</div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">Thanks..</div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto"><br></div><div><br><div class="gmail_quote"><div>On Wed, 3 Jan 2018 at 7:53 PM, Bogdan-Andrei Iancu <<a href="mailto:bogdan@opensips.org">bogdan@opensips.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div bgcolor="#FFFFFF" text="#000000">
    <tt>Hello Vishal,<br>
      <br>
      A Happy New Year too !<br>
      <br>
      With the avp_db_query() you can run any kind of raw query, so just
      write your SQL query exactly as you do in your mysql client CLI.<br>
      <br>
      Regards,<br>
    </tt>
    <pre class="m_286329341397966130moz-signature" cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a class="m_286329341397966130moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a>
OpenSIPS Summit 2018
  <a class="m_286329341397966130moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2018Amsterdam" target="_blank">http://www.opensips.org/events/Summit-2018Amsterdam</a>
</pre></div><div bgcolor="#FFFFFF" text="#000000">
    <div class="m_286329341397966130moz-cite-prefix">On 01/01/2018 07:16 PM, Vishal Pai
      wrote:<br>
    </div>
    </div><div bgcolor="#FFFFFF" text="#000000"><blockquote type="cite">
      <div>
        <div>
          <div>
            <div>
              <div>Hi Everyone<br>
                <br>
              </div>
              Merry Christmas and Happy New Year to all.<br>
              <br>
            </div>
            As i am new to opensips, I just want to know what is the
            best possible way to do Insert, Update and Delete using
            avp_db_query.<br>
            <br>
            <br>
          </div>
          Thanks <br>
        </div>
        Vishal Pai <br>
      </div>
      <br>
      <fieldset class="m_286329341397966130mimeAttachmentHeader"></fieldset>
      <br>
      </blockquote></div><div bgcolor="#FFFFFF" text="#000000"><blockquote type="cite"><pre>_______________________________________________
Users mailing list
<a class="m_286329341397966130moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a class="m_286329341397966130moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </div>

</blockquote></div></div>