Rename a MySQL table using SQL statement

Question

I want to rename an existing table using SQL statement:

I have already tried:

mysql_query("RENAME '$renameFolder' TO '$newName'");
mysql_query("ALTER TABLE '$renameFolder' RENAME TO '$newName'");
mysql_query("RENAME TABLE '$renameFolder' TO '$newName'");

Using any of the 3 statements I'm always getting the same error message:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax"

Please tell me what I'm doing wrong!

WARNING: mysql_query is an obsolete interface and should not be used in new applications as it's being removed in future versions of PHP. A modern replacement like PDO is not hard to learn. If you're new to PHP, a guide like PHP The Right Way can help explain best practices. — tadman
– tadman, Commented Feb 2, 2015 at 16:28

Overv · Accepted Answer · 2012-03-03 19:57:44Z

6

Try using backquotes instead, e.g.:

mysql_query( "RENAME TABLE `" . $renameFolder . "` TO `" . $newname . "`" );

edited Mar 3, 2012 at 19:57

answered Mar 3, 2012 at 19:45

Overv

8,5393 gold badges44 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

artragis Over a year ago

I think it is that. logically we have to warp table name betwin ` not '.

Overv Over a year ago

I tried it on my own set up and removing the quotes fixed it. I suspect that you have non-alphanumeric characters in your table name. Try it with ` quotes instead as atragis said.

user1216858 Over a year ago

do you mean like that: mysql_query("RENAME " . '$renameFolder' . " TO ". '$newName') ?

Brad Larson · Accepted Answer · 2014-08-24 18:51:05Z

2

The mysql query for rename table is
RENAME TABLE old_name TO new_name

edited Aug 24, 2014 at 18:51

Brad Larson

170k45 gold badges401 silver badges574 bronze badges

answered Jan 17, 2014 at 5:49

php

4,4551 gold badge27 silver badges13 bronze badges

Comments

Varuna · Accepted Answer · 2014-11-18 13:14:00Z

2

appected answer from mySQLi:

$db=mysqli_connect("localhost","root","password","database");
$oldFolder="old_table_name";
$newname="new_table_name";
mysqli_query($db,"RENAME TABLE `" . $oldFolder . "` TO `" . $newname . "`");

Good Luck!

answered Nov 18, 2014 at 13:14

Varuna

1683 silver badges15 bronze badges

Comments

Liftoff · Accepted Answer · 2012-03-03 19:48:03Z

1

Have you connected to the server properly?

Have you selected the db the table is in?

If you have, then you should be able to run this:

mysql_query("ALTER TABLE table_name RENAME TO new_table_name");

answered Mar 3, 2012 at 19:48

Liftoff

25.6k16 gold badges74 silver badges127 bronze badges

2 Comments

user1216858 Over a year ago

Yes the table is in. i aready used this statement and is not working for me.

Liftoff Over a year ago

Then you have to put `` around the table names or concatenate the strings with the variables as suggested by Overv.

Kerem · Accepted Answer · 2015-02-02 16:59:49Z

1

RENAME TABLE `jshop`.`mob_apple` TO `jshop`.`item_mobile`;

edited Feb 2, 2015 at 16:59

Kerem

11.6k5 gold badges61 silver badges58 bronze badges

answered Feb 2, 2015 at 16:25

user4398229

Comments

Amit Verma · Accepted Answer · 2021-07-30 09:21:21Z

1

With mysqli object oriented interface you can use the following to rename your table

 $sql = "RENAME TABLE OldName TO NewName";
//if the query is successful
if ($conn->query($sql) === TRUE) {
echo "Table  renamed successfully";
}
//If something goes wrong

 else {
 echo "Error creating table: " . $conn->error;
 }

answered Jul 30, 2021 at 9:21

Amit Verma

41.3k21 gold badges97 silver badges117 bronze badges

Comments

mishmash · Accepted Answer · 2012-03-03 19:46:21Z

0

Try it without the quotes so the final query will look like:

mysql_query ("ALTER TABLE foo RENAME TO bar");

Hope this helps.

answered Mar 3, 2012 at 19:46

mishmash

4,4683 gold badges36 silver badges57 bronze badges

Collectives™ on Stack Overflow

Rename a MySQL table using SQL statement

7 Answers 7

3 Comments

Comments

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

3 Comments

Comments

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related