Bug #44364 The error 1017 while renaming the table
| Submitted: | 20 Apr 2009 13:22 | Modified: | 20 Apr 2009 14:19 |
|---|---|---|---|
| Reporter: | pradeep somani | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: General | Severity: | S3 (Non-critical) |
| Version: | 5.0.41-community-nt | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | 1017, rename table, temporary table | ||
[20 Apr 2009 13:22]
pradeep somani
[20 Apr 2009 13:32]
pradeep somani
You cannot use RENAME to rename a TEMPORARY table. However, you can use ALTER TABLE instead: REF http://dev.mysql.com/doc/refman/5.1/en/rename-table.html Please remove this bug listing
[22 Dec 2009 6:49]
Sveta Smirnova
See also bug #1154
[27 Apr 2011 0:57]
Jian Wu
I created a regular table by importing an existing mysql data file (source data.sql) but still have this error when I was trying to rename the table.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.