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

User · Answer

ALTER TABLE  group  RENAME  member    group is keyword so you must have to enclose into group

User · Answer

Please try  RENAME TABLE   oldTableName  TO   newTableName

User · Answer

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

User · Answer

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

User · Answer

RENAME TABLE tb1 TO tb2    tb1 - current table name  tb2 - the name you want your table to be called

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

ALTER TABLE old table name RENAME new table name    or   RENAME TABLE old table name TO new table name

User · Answer

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

User · Answer

You can use   RENAME TABLE  group  TO  member     Use back tick     instead of single quote

User · Answer

Rename a table in MySQL     ALTER TABLE current name RENAME new name

User · Answer

Table name change  RENAME TABLE old table name TO new table name

User · Answer

Try any of these     RENAME TABLE  group  TO  member     or  ALTER TABLE  group  RENAME  member

User · Answer

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

User · Answer

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

[mysql] Rename a table in MySQL

Examples related to mysql

Examples related to database

Examples related to table-rename