diff options
Diffstat (limited to 'Docs')
| -rw-r--r-- | Docs/manual.texi | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index b5d80b7fd03..1bf3afdc0b0 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -16818,9 +16818,10 @@ from a database to another: RENAME TABLE current_database.table_name TO other_database.table_name; @end example -When you execute @code{RENAME}, you can't have any locked tables or active -transactions. You must also have the @code{ALTER TABLE} privilege on both -the old and the new table. +When you execute @code{RENAME}, you can't have any locked tables or +active transactions. You must also have the @code{ALTER TABLE} +privilege on the original table and @code{CREATE} and @code{INSERT} +privilege on the new table. If @strong{MySQL} encounters any errors in a multiple table rename, it will do a reverse rename for all renamed tables to get everything back @@ -18222,7 +18223,9 @@ file name, @strong{MySQL} will close and reopen the update log file. @item @code{PRIVILEGES} @tab Reloads the privileges from the grant tables in the @code{mysql} database. -@item @code{TABLES} @tab Closes all open tables. +@item @code{TABLES} @tab Closes all open tables and force all tables in use to be closed. + +@item @code{TABLES table_name [,table_name...]} @tab Flush only the given tables @item @code{TABLES WITH READ LOCK} @tab Closes all open tables and locks all tables for all databases with a read until one executes @code{UNLOCK TABLES}. |