<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>