Author: plavin
Date: 2007-03-13 16:58:53 +0100 (Tue, 13 Mar 2007)
New Revision: 5334
Log:
Add more functions
Modified:
trunk/dynamic-docs/opsfunctions/opfunctions.xml
Modified: trunk/dynamic-docs/opsfunctions/opfunctions.xml
===================================================================
--- trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-03-13 15:34:10 UTC (rev 5333)
+++ trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-03-13 15:58:53 UTC (rev 5334)
Changed blocks: 2, Lines Added: 90, Lines Deleted: 1; 3648 bytes
@@ -1798,7 +1798,7 @@
</versions>
</function>
- <function id="weekofyesr" class="datetime">
+ <function id="weekofyear" class="datetime">
<display>WEEKOFYEAR()</display>
<description lang="en">Return the calendar week of the date (1-53)</description>
<arguments>
@@ -1831,4 +1831,93 @@
<manual version="5.1"/>
</versions>
</function>
+
+ <function id="yearweek" class="datetime">
+ <display>YEARWEEK()</display>
+ <description lang="en">Return the year and week</description>
+ <arguments>
+ <format><![CDATA[<replaceable>date</replaceable>]]></format>
+ <argument seq="1" name="expr" type="string">Properly formatted string</argument>
+
+ </arguments>
+ <arguments>
+ <format><![CDATA[<replaceable>date</replaceable>,<replaceable>mode</replaceable>]]></format>
+ <argument seq="1" name="expr" type="string">Properly formatted string</argument>
+ <argument seq="1" name="expr" type="numeric">Week start indicator</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="updatexml" class="xml">
+ <display>UPDATEXML()</display>
+ <description lang="en">Return replaced XML fragment</description>
+ <arguments>
+ <format><![CDATA[<replaceable>xml_target</replaceable>,
+ <replaceable>xpath_expr</replaceable>,
+ <replaceable>new_xml</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="string">XML Target</argument>
+ <argument seq="2" name="expr" type="string">XPath</argument>
+ <argument seq="3" name="expr" type="numeric">New XML </argument>
+ </arguments>
+ <return type="string"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+
+ <function id="bit-count" class="bit">
+ <display>BIT_COUNT()</display>
+ <description lang="en">Return the number of bits that are set</description>
+ <arguments>
+ <format><![CDATA[<replaceable>N</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="aes_encrypt" class="encryption">
+ <display>AES_ENCRYPT()</display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[<replaceable>str</replaceable>,<replaceable>key_str</replaceable>]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ <argument seq="2" name="expr" type="numeric"></argument>
+ </arguments>
+ <arguments>
+ <format><![CDATA[<replaceable>crypt_str</replaceable>,<replaceable>key_str</replaceable>]]></format>
+ <argument seq="1" name="expr" type="string"></argument>
+ <argument seq="1" name="expr" type="string"></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: r5334 - trunk/dynamic-docs/opsfunctions | plavin | 13 Mar |