How to rename a mysql table in php?

Question

How to rename a mysql table in php?

Navigation

#1 by (3 votes)
#2 by (0 votes)

1

What I want is to rename a table from php. I have tried with this:

mysql_query("RENAME TABLE ". $tablaNom ." TO '.$nombre.'") or die(mysql_error());

The previous line renames me the table but it puts a "." in the name and when I want to make a select it tells me that the table does not exist.

Likewise I have tried using the following line:

mysql_query("RENAME TABLE ". $tablaNom ." TO '".$nombre."'") or die(mysql_error());

But it says the following: "Incorrect table name".

I hope you can help me, and thank you in advance.

mysql php

asked by A.Monreal 14.07.2016 в 20:15

source

2 answers

How can I modify an xml file, delete and write a child, in java? Have a website in several Idomas [closed]

score 3 · Answer 1

3

You're on the right track, you needed to define the backspace quotes: ''

mysql_query( "RENAME TABLE '" . $tablaNom . "' TO '" . $nombre. "'" ) or die(mysql_error());

answered by 14.07.2016 в 20:19

score 0 · Answer 2

After a lot of struggle I managed to make it work, I just did not understand why it worked. What I did was remove the quotes, the periods and the backspace quotes of the second variable; that is, the one that contains the new name of the table.

mysql_query( "RENAME TABLE '" . $tablaNom . "' TO  $nombre " ) or die(mysql_error());

Anyway, thank you and I hope this answer will be of help to other people.

Greetings