|
1994.5.16
by Stewart Smith
remove \r at end of line as they cause kitten injuries. |
1 |
RENAME
|
|
1878.5.6
by Brian Aker
A couple of fixes to documentation. |
2 |
======
|
3 |
||
4 |
Rename a table, or group of tables. |
|
|
1945.3.9
by Marisa Plumb
changes in cross-references |
5 |
|
|
1994.4.123
by Marisa Plumb
doc fixes |
6 |
If you have an existing table old_name, you can create another table new_name; it will be empty but reptant he same structure, and then replace the existing table with the empty one as follows (assuming backup_table does not already exist): |
7 |
||
8 |
.. code-block:: mysql |
|
9 |
||
10 |
CREATE TABLE new_name (...); |
|
11 |
RENAME TABLE old_name TO backup_table, new_name TO old_name; |
|
12 |
||
13 |
When using a statement to rename more than one table, the order of operations are done from left to right. To swap two table names, use the following (assuming tmp_table does not already exist): |
|
14 |
||
15 |
.. code-block:: mysql |
|
16 |
||
17 |
RENAME TABLE old_name TO tmp_table, |
|
18 |
new_name TO old_name, |
|
19 |
tmp_table TO new_name; |
|
20 |
||
21 |
While RENAME is running, no other session can access any of the involved tables. |
|
22 |
||
|
2194.5.3
by Andrew Hutchings
Markup fixes |
23 |
.. seealso:: |
24 |
:doc:`/alter_table` |