Author: paul
Date: 2007-10-23 20:03:58 +0200 (Tue, 23 Oct 2007)
New Revision: 8269
Log:
r31557@polar: paul | 2007-10-23 12:00:55 -0500
Remove RENAME DATABASE from 5.2 manual.
Modified:
trunk/refman-5.2/sql-syntax.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:31554
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:25981
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:20005
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:31557
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:25981
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:20005
Modified: trunk/refman-5.2/sql-syntax.xml
===================================================================
--- trunk/refman-5.2/sql-syntax.xml 2007-10-23 16:57:59 UTC (rev 8268)
+++ trunk/refman-5.2/sql-syntax.xml 2007-10-23 18:03:58 UTC (rev 8269)
Changed blocks: 1, Lines Added: 0, Lines Deleted: 111; 3928 bytes
@@ -5637,117 +5637,6 @@
</section>
- <section id="rename-database">
-
- <title><literal>RENAME DATABASE</literal> Syntax</title>
-
- <indexterm>
- <primary>RENAME DATABASE</primary>
- </indexterm>
-
- <remark role="help-topic" condition="RENAME DATABASE"/>
-
- <remark role="help-keywords">
- RENAME DATABASE SCHEMA
- </remark>
-
- <remark role="help-syntax"/>
-
-<programlisting>
-RENAME {DATABASE | SCHEMA} <replaceable>db_name</replaceable> TO <replaceable>new_db_name</replaceable>;
-</programlisting>
-
- <remark role="help-description-begin"/>
-
- <para>
- This statement renames a database. It requires the
- <literal>ALTER</literal> and <literal>DROP</literal> privileges
- for the database, and the <literal>CREATE</literal> privilege
- for the new database. <literal>RENAME SCHEMA</literal> is a
- synonym for <literal>RENAME DATABASE</literal>.
- </para>
-
- <para>
- When the server receives this statement, it creates a new
- database. Then it moves tables and other database objects such
- as triggers to the new database. It also updates the
- <literal>Db</literal> column in the system tables for objects
- such as stored routines and events. Finally, the server drops
- the old database.
- </para>
-
- <para>
- <emphasis role="bold">Note that currently there are these
- limitations:</emphasis>
-
- <itemizedlist>
-
- <listitem>
- <para>
- <literal>RENAME DATABASE</literal> does not change any
- account privileges listed in the system tables. They must
- be changed manually.
- </para>
- </listitem>
-
- <listitem>
- <remark role="todo">
- This item replaces the following commented-out item until
- Bugs #28360, #17565 are fixed. And perhaps then even the
- commented-out item will not apply.
- </remark>
-
- <para>
- <literal>RENAME DATABASE</literal> destroys any stored
- routines or events associated with the original database.
- </para>
- </listitem>
-
-<!--
- <listitem>
- <para>
- <literal>RENAME DATABASE</literal> does not migrate any
- stored routines or events to the new schema name. This
- means that:
-
- <itemizedlist>
-
- <listitem>
- <para>
- For stored routines, it does not change any values
- in the <literal>ROUTINE_SCHEMA</literal> column of
- the <literal>INFORMATION_SCHEMA.ROUTINES</literal>
- table, or in the <literal>db</literal> column of the
- <literal>mysql.proc</literal> table.
- </para>
- </listitem>
-
- <listitem>
- <para>
- For events, it does not change any values in the
- <literal>EVENT_SCHEMA</literal> column of the
- <literal>INFORMATION_SCHEMA.EVENTS</literal> table,
- or in the <literal>db</literal> column of the
- <literal>mysql.event</literal> table.
- </para>
- </listitem>
-
- </itemizedlist>
- </para>
- </listitem>
--->
-
- </itemizedlist>
- </para>
-
- <remark role="help-description-end"/>
-
- <para>
- This statement was added in MySQL 5.1.7.
- </para>
-
- </section>
-
<section id="rename-table">
<title><literal>RENAME TABLE</literal> Syntax</title>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r8269 - in trunk: . refman-5.2 | paul | 23 Oct |
