svn commit - mysqldoc@docsrva: r1180 - in trunk: refman-4.1 refman-5.0 refman-5.1

[stefan]

Author: shinz
Date: 2006-02-02 10:55:34 +0100 (Thu, 02 Feb 2006)
New Revision: 1180

Log:
Add link from GROUP_CONCAT() to CONCAT() (bug #16860)

Modified:
   trunk/refman-4.1/functions.xml
   trunk/refman-4.1/replication.xml
   trunk/refman-5.0/functions.xml
   trunk/refman-5.1/functions.xml

Modified: trunk/refman-4.1/functions.xml
===================================================================
--- trunk/refman-4.1/functions.xml	2006-02-02 09:34:09 UTC (rev 1179)
+++ trunk/refman-4.1/functions.xml	2006-02-02 09:55:34 UTC (rev 1180)
@@ -14301,6 +14301,11 @@
             <literal>MID(<replaceable>expr</replaceable>,1,255)</literal>
             instead.
           </para>
+          
+          <para>
+            See also <literal>CONCAT()</literal> and
+            <literal>CONCAT_WS()</literal>: <xref linkend="string-functions"/>.
+          </para>
         </listitem>
 
         <listitem>

Modified: trunk/refman-4.1/replication.xml
===================================================================
--- trunk/refman-4.1/replication.xml	2006-02-02 09:34:09 UTC (rev 1179)
+++ trunk/refman-4.1/replication.xml	2006-02-02 09:55:34 UTC (rev 1180)
@@ -1690,7 +1690,29 @@
           avoid 4.1.0 in a replication scenario.)
         </para>
       </listitem>
-
+<!-- closes bug #16486 - remove after Guilhem OK - copy to 5.0 and 5.1 - adapt
+  for 4.1/5.0/5.1      
+<listitem>
+  <para>
+    User privileges are replicated only if the <literal>mysql</literal>
+    database is replicated. That is, the <literal>GRANT</literal>,
+    <literal>REVOKE</literal>, <literal>SET PASSWORD</literal>,
+    <literal>CREATE USER</literal>, and <literal>DROP USER</literal>
+    statements take effect on the slave only if the replication setup
+    includes the <literal>mysql</literal> database.
+  </para>
+  <para>
+    If you're replicating all databases, but don't want statements
+    that affect user privileges to be replicated, there's no way to
+    instruct a slave to not replicate privilege-related statements. A
+    simple workaround, however, is to set up the slave to not replicate
+    the <literal>mysql</literal> database, using the
+    <option>- -replicate-wild-ignore-table=mysql.%</option> option. That
+    option is available as of MySQL 4.0.13. The slave will still issue
+    privilege-related SQL statements, but they won't take effect.
+  </para>
+</listitem>
+-->
       <listitem>
         <para>
           The <literal>GET_LOCK()</literal>,

Modified: trunk/refman-5.0/functions.xml
===================================================================
--- trunk/refman-5.0/functions.xml	2006-02-02 09:34:09 UTC (rev 1179)
+++ trunk/refman-5.0/functions.xml	2006-02-02 09:55:34 UTC (rev 1180)
@@ -14364,6 +14364,11 @@
       <literal>LIST()</literal> does have a default sorting order.
     </para>
 -->
+          <para>
+            See also <literal>CONCAT()</literal> and
+            <literal>CONCAT_WS()</literal>: <xref linkend="string-functions"/>.
+          </para>
+          
         </listitem>
 
         <listitem>

Modified: trunk/refman-5.1/functions.xml
===================================================================
--- trunk/refman-5.1/functions.xml	2006-02-02 09:34:09 UTC (rev 1179)
+++ trunk/refman-5.1/functions.xml	2006-02-02 09:55:34 UTC (rev 1180)
@@ -14751,6 +14751,11 @@
       <literal>LIST()</literal> does have a default sorting order.
     </para>
 -->
+          <para>
+            See also <literal>CONCAT()</literal> and
+            <literal>CONCAT_WS()</literal>: <xref linkend="string-functions"/>.
+          </para>
+          
         </listitem>
 
         <listitem>