RENAME TABLE / ALTER TABLE not working

Question

I'm trying to rename a table in a Mysql db, from PHP, but this code doesn't work:

$sql = "RENAME TABLE dbname.table TO dbname.tabletmp;"; 
$conn->query($sql);

I've tried to use also ALTER TABLE or the '' for the table names, but nothing. Any ideas?

It seems that in PHP ALTER TABLE isn't a command :/

Are you getting some exception or error message? Rename table syntax looks fine. Alter table cannot be used for renaming table. — Keyur Panchal, Jun 19 '17 at 07:44
This [answer](https://stackoverflow.com/a/37786534/5513005) may help you — Yash Karanke, Jun 19 '17 at 07:44
Possible duplicate of [Rename a table in MySQL](https://stackoverflow.com/questions/12650370/rename-a-table-in-mysql) — RAUSHAN KUMAR, Jun 19 '17 at 07:44
First `use DATABASE_NAME` and then `RENAME TABLE tb1 TO tb2;` — Milan Chheda, Jun 19 '17 at 07:44
No, i haven't any exception or error message. The page stops loading when arrives at that line of code... — Giuse_07, Jun 19 '17 at 07:45
@MilanChheda now the page load properly, but the query doesn't do anything. — Giuse_07, Jun 19 '17 at 07:49

score 0 · Answer 1 · answered Jun 19 '17 at 08:29

It seems that in PHP ALTER TABLE isn't a command :/

PHP doesn't care about SQL. Not even $conn->query() cares about it. You pass it a string and it passes it further to the server.

Make sure the user you use to connect has the necessary privileges to rename a table. The documentation of RENAME TABLE says:

When you execute RENAME TABLE, you cannot have any locked tables or active transactions. You must also have the ALTER and DROP privileges on the original table, and the CREATE and INSERT privileges on the new table.

score -1 · Answer 2 · answered Jun 19 '17 at 08:19

-1

Try this

$sql = "RENAME TABLE `" . $oldname . "` TO `" . $newname . "`" ;
$conn->query($sql);

answered Jun 19 '17 at 08:19

Sehdev

5,486
3
11
34

RENAME TABLE / ALTER TABLE not working

2 Answers2