From: paul
Date: December 16 2005 12:02am
Subject: svn commit - mysqldoc@docsrva: r572 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-common
List-Archive: http://lists.mysql.com/commits/194
Message-Id: <200512160002.jBG02Nqd005848@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: paul
Date: 2005-12-16 01:02:22 +0100 (Fri, 16 Dec 2005)
New Revision: 572
Log:
r4807@frost: paul | 2005-12-15 16:23:48 -0600
Split CREATE FUNCTION/DROP FUNCTION into two sections
and bifurcate the help markup to make it more specific.
Modified:
trunk/
trunk/refman-4.1/extending-mysql.xml
trunk/refman-5.0/extending-mysql.xml
trunk/refman-5.1/extending-mysql.xml
trunk/refman-common/titles.en.ent
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:4806
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1671
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:4807
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1671
Modified: trunk/refman-4.1/extending-mysql.xml
===================================================================
--- trunk/refman-4.1/extending-mysql.xml 2005-12-16 00:02:11 UTC (rev 571)
+++ trunk/refman-4.1/extending-mysql.xml 2005-12-16 00:02:22 UTC (rev 572)
@@ -657,18 +657,14 @@
CREATE FUNCTION
-
- DROP FUNCTION
-
-
- deleting
+ creating
function
function
- deleting
+ creating
@@ -684,20 +680,17 @@
user-defined
-
+
- AGGREGATE CREATE FUNCTION DROP STRING REAL INTEGER RETURNS
- SONAME
+ AGGREGATE CREATE FUNCTION STRING REAL INTEGER RETURNS SONAME
CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL}
- SONAME shared_library_name
-
-DROP FUNCTION function_name
+ SONAME shared_library_name
@@ -724,14 +717,11 @@
To create a function, you must have the
INSERT and privilege for the
- mysql database. To drop a function, you must
- have the DELETE privilege for the
mysql database. This is because
CREATE FUNCTION adds a row to the
mysql.func system table that records the
- function's name, type, and shared library name, and
- DROP FUNCTION deletes the function's row from
- that table. If you do not have this table, you should run the
+ function's name, type, and shared library name. If you do not
+ have this table, you should run the
mysql_fix_privilege_tables script to create
it. See .
@@ -771,6 +761,70 @@
+
+
+ &title-drop-function;
+
+
+ DROP FUNCTION
+
+
+
+ deleting
+ function
+
+
+
+ function
+ deleting
+
+
+
+ UDFs
+
+
+
+ User-defined functions
+
+
+
+ Functions
+ user-defined
+
+
+
+
+
+ DROP FUNCTION
+
+
+
+
+
+DROP FUNCTION function_name
+
+
+
+
+
+
+
+ This statement drops the user-defined function (UDF) named
+ function_name.
+
+
+
+ To drop a function, you must have the DELETE
+ privilege for the mysql database. This is
+ because DROP FUNCTION removes a row from the
+ mysql.func system table that records the
+ function's name, type, and shared library name.
+
+
+
+
+
+
&title-adding-udf;
Modified: trunk/refman-5.0/extending-mysql.xml
===================================================================
--- trunk/refman-5.0/extending-mysql.xml 2005-12-16 00:02:11 UTC (rev 571)
+++ trunk/refman-5.0/extending-mysql.xml 2005-12-16 00:02:22 UTC (rev 572)
@@ -652,18 +652,14 @@
CREATE FUNCTION
-
- DROP FUNCTION
-
-
- deleting
+ creating
function
function
- deleting
+ creating
@@ -679,20 +675,17 @@
user-defined
-
+
- AGGREGATE CREATE FUNCTION DROP STRING REAL INTEGER RETURNS
- SONAME
+ AGGREGATE CREATE FUNCTION STRING REAL INTEGER DECIMAL RETURNS SONAME
CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL}
- SONAME shared_library_name
-
-DROP FUNCTION function_name
+ SONAME shared_library_name
@@ -726,14 +719,11 @@
To create a function, you must have the
INSERT and privilege for the
- mysql database. To drop a function, you must
- have the DELETE privilege for the
mysql database. This is because
CREATE FUNCTION adds a row to the
mysql.func system table that records the
- function's name, type, and shared library name, and
- DROP FUNCTION deletes the function's row from
- that table. If you do not have this table, you should run the
+ function's name, type, and shared library name. If you do not
+ have this table, you should run the
mysql_fix_privilege_tables script to create
it. See .
@@ -772,6 +762,70 @@
+
+
+ &title-drop-function;
+
+
+ DROP FUNCTION
+
+
+
+ deleting
+ function
+
+
+
+ function
+ deleting
+
+
+
+ UDFs
+
+
+
+ User-defined functions
+
+
+
+ Functions
+ user-defined
+
+
+
+
+
+ DROP FUNCTION
+
+
+
+
+
+DROP FUNCTION function_name
+
+
+
+
+
+
+
+ This statement drops the user-defined function (UDF) named
+ function_name.
+
+
+
+ To drop a function, you must have the DELETE
+ privilege for the mysql database. This is
+ because DROP FUNCTION removes a row from the
+ mysql.func system table that records the
+ function's name, type, and shared library name.
+
+
+
+
+
+
&title-adding-udf;
Modified: trunk/refman-5.1/extending-mysql.xml
===================================================================
--- trunk/refman-5.1/extending-mysql.xml 2005-12-16 00:02:11 UTC (rev 571)
+++ trunk/refman-5.1/extending-mysql.xml 2005-12-16 00:02:22 UTC (rev 572)
@@ -911,18 +911,14 @@
CREATE FUNCTION
-
- DROP FUNCTION
-
-
- deleting
+ creating
function
function
- deleting
+ creating
@@ -938,20 +934,17 @@
user-defined
-
+
- AGGREGATE CREATE FUNCTION DROP STRING REAL INTEGER RETURNS
- SONAME
+ AGGREGATE CREATE FUNCTION STRING REAL INTEGER DECIMAL RETURNS SONAME
CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL}
- SONAME shared_library_name
-
-DROP FUNCTION function_name
+ SONAME shared_library_name
@@ -989,14 +982,11 @@
To create a function, you must have the
INSERT and privilege for the
- mysql database. To drop a function, you must
- have the DELETE privilege for the
mysql database. This is because
CREATE FUNCTION adds a row to the
mysql.func system table that records the
- function's name, type, and shared library name, and
- DROP FUNCTION deletes the function's row from
- that table. If you do not have this table, you should run the
+ function's name, type, and shared library name. If you do not
+ have this table, you should run the
mysql_fix_privilege_tables script to create
it. See .
@@ -1035,6 +1025,70 @@
+
+
+ &title-drop-function;
+
+
+ DROP FUNCTION
+
+
+
+ deleting
+ function
+
+
+
+ function
+ deleting
+
+
+
+ UDFs
+
+
+
+ User-defined functions
+
+
+
+ Functions
+ user-defined
+
+
+
+
+
+ DROP FUNCTION
+
+
+
+
+
+DROP FUNCTION function_name
+
+
+
+
+
+
+
+ This statement drops the user-defined function (UDF) named
+ function_name.
+
+
+
+ To drop a function, you must have the DELETE
+ privilege for the mysql database. This is
+ because DROP FUNCTION removes a row from the
+ mysql.func system table that records the
+ function's name, type, and shared library name.
+
+
+
+
+
+
&title-adding-udf;
Modified: trunk/refman-common/titles.en.ent
===================================================================
--- trunk/refman-common/titles.en.ent 2005-12-16 00:02:11 UTC (rev 571)
+++ trunk/refman-common/titles.en.ent 2005-12-16 00:02:22 UTC (rev 572)
@@ -264,7 +264,7 @@
myisamchk for Crash Recovery">
CREATE DATABASE Syntax">
-CREATE FUNCTION/DROP FUNCTION Syntax">
+CREATE FUNCTION Syntax">
CREATE INDEX Syntax">
CREATE PROCEDURE and CREATE FUNCTION">
CREATE TABLE Syntax">
@@ -328,6 +328,7 @@
DROP DATABASE Syntax">
+DROP FUNCTION Syntax">
DROP INDEX Syntax">
DROP PROCEDURE and DROP FUNCTION">
DROP TABLE Syntax">