Rename a table in MySQL

Question

Renaming a table is not working in MySQL

RENAME TABLE group TO member;

The error message is

#1064 - You have an error in your SQL syntax; check the manual that corresponds
        to your MySQL server version for the right syntax to use near 'group 
        RENAME TO member' at line 1

The query is working fine on other tables for me, but not with the table group.

Answer 1

group is a keyword (part of GROUP BY) in MySQL, you need to surround it with backticks to show MySQL that you want it interpreted as a table name:

RENAME TABLE `group` TO `member`;

added(see comments)- Those are not single quotes.

Answer 2

Please try

RENAME TABLE  `oldTableName` TO  `newTableName`

Answer 3

The mysql query for rename table is

Rename Table old_name TO new_name

In your query, you've used group which one of the keywords in MySQL. Try to avoid mysql keywords for name while creating table, field name and so on.

Answer 4

ALTER TABLE old_table_name RENAME new_table_name;

or

RENAME TABLE old_table_name TO new_table_name;

Answer 5

Table name change

RENAME TABLE old_table_name TO new_table_name;

Answer 6

Rename a table in MySQL :

ALTER TABLE current_name RENAME new_name;

Answer 7

group - is a reserved word in MySQL, that's why you see such error.

#1064 - You have an error in your SQL syntax; check the manual that corresponds
        to your MySQL server version for the right syntax to use near 'group 
        RENAME TO member' at line 1

You need to wrap table name into backticks:

RENAME TABLE `group` TO `member`;

Answer 8

ALTER TABLE `group` RENAME `member`

group is keyword so you must have to enclose into group

Answer 9

RENAME TABLE tb1 TO tb2;

tb1 - current table name. tb2 - the name you want your table to be called.

Answer 10

For Mysql 5.6.18 use the following command

ALTER TABLE `old_table` RENAME TO `new_table`

Also if there is an error saying ".... near RENAME TO ..." try removing the tick `

Answer 11

According to mysql docs: "to rename TEMPORARY tables, RENAME TABLE does not work. Use ALTER TABLE instead."

So this is the most portable method:

ALTER TABLE `old_name` RENAME `new_name`;

Answer 12

Try any of these

RENAME TABLE `group` TO `member`;

or

ALTER TABLE `group` RENAME `member`;

Answer 13

Running The Alter Command

1.Click the SQL tab at the top.

2.In the text box enter the following command: ALTER TABLE exampletable RENAME TO new_table_name;

3.Click the go button.

source : https://my.bluehost.com/hosting/help/2158

Answer 14

You can use

RENAME TABLE `group` TO `member`;

Use back tick (`) instead of single quote (').

Answer 15

Rename table
Syntax The syntax to rename a table in MySQL is:

ALTER TABLE table_name
RENAME TO new_table_name;

Example
Let's look at an example that shows how to rename a table in MySQL using the ALTER TABLE statement.
or example:

ALTER TABLE contacts
RENAME TO people;

Answer 16

Without giving the database name the table is can't be renamed in my case, I followed the below command to rename the table.

RENAME TABLE current_db.tbl_name TO current_db.tbl_name;

Answer 17

Right Click on View > New Query

And Type: EXEC sp_rename 'Table', 'NewName'

Then Click on Run button at the top left corner of the page.