Author: plavin
Date: 2007-03-09 21:51:37 +0100 (Fri, 09 Mar 2007)
New Revision: 5293
Log:
Add functions
Modified:
trunk/dynamic-docs/opsfunctions/opfunctions.xml
Modified: trunk/dynamic-docs/opsfunctions/opfunctions.xml
===================================================================
--- trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-03-09 19:24:23 UTC (rev 5292)
+++ trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-03-09 20:51:37 UTC (rev 5293)
Changed blocks: 6, Lines Added: 142, Lines Deleted: 3; 5809 bytes
@@ -670,7 +670,7 @@
</versions>
</function>
- <function id="log10" class="">
+ <function id="log10" class="mathematical">
<display>LOG10</display>
<description lang="en">Return the base-10 logarithm of the argument</description>
<arguments>
@@ -686,9 +686,9 @@
</versions>
</function>
- <function id="mod" class="mathematical">
+ <function id="mod2" class="mathematical">
<display>MOD</display>
- <description lang="en"></description>
+ <description lang="en">Return the modulus</description>
<arguments>
<format><![CDATA[MOD(<replaceable>N</replaceable>,<replaceable>M</replaceable>)]]></format>
<argument seq="1" name="expr" type="numeric">Dividend</argument>
@@ -802,6 +802,93 @@
</versions>
</function>
+ <function id="sin" class="mathematical">
+ <display>SIN</display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[SIN(<replaceable>X</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric">Radians</argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="sqrt" class="mathematical">
+ <display></display>
+ <description lang="en">Return the square root of the argument</description>
+ <arguments>
+ <format><![CDATA[SQRT(<replaceable>X</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="tan" class="mathematical">
+ <display>TAN</display>
+ <description lang="en">Return the tangent of the argument</description>
+ <arguments>
+ <format><![CDATA[TAN(<replaceable>X</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric">Radians</argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="truncate" class="">
+ <display></display>
+ <description lang="en">Truncate to specified number of decimal places</description>
+ <arguments>
+ <format><![CDATA[TRUNCATE(<replaceable>X</replaceable>,<replaceable>D</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ <argument seq="1" name="expr" type="numeric">Number of decimal places</argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="adddate" class="date-time">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[ADDDATE(<replaceable>date</replaceable>,INTERVAL
+ <replaceable>expr</replaceable>
+ <replaceable>unit</replaceable>)]]></format>
+ <format><![CDATA[ADDDATE(<replaceable>expr</replaceable>,<replaceable>days</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric">date</argument>
+ <argument seq="2" name="expr" type="numeric">INTERVAL number unit</argument>
+ <argument seq="1" name="expr" type="date">date</argument>
+ <argument seq="2" name="expr" type="date">days</argument>
+ </arguments>
+ <return type="date"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
<function id="" class="">
<display></display>
<description lang="en"></description>
@@ -818,6 +905,7 @@
</versions>
</function>
+
<function id="" class="">
<display></display>
<description lang="en"></description>
@@ -850,6 +938,7 @@
</versions>
</function>
+
<function id="" class="">
<display></display>
<description lang="en"></description>
@@ -866,5 +955,55 @@
</versions>
</function>
+ <function id="" class="">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+
+ <function id="" class="">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="" class="">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+
</opfunctions>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5293 - trunk/dynamic-docs/opsfunctions | plavin | 9 Mar |
