Sign in Get Started

How To Rename Table Using MySQL RENAME TABLE Statement

David Truong 
Because business requirements change, we need to rename the current table to a new one to better reflect the new situation. MySQL provides us with a very useful statement that changes the name of one or more tables.

To change one or more tables, we use the RENAME TABLE statement as follows:

RENAME TABLE old_table_name TO new_table_name;
The old table ( old_table_name) must exist, and the new table ( new_table_name) must not. If the new table new_table_name does exist, the statement will fail.

In addition to the tables, we can use the RENAME TABLE statement to rename views.
View another examples Add Own solution
Log in, to leave a comment

4
9
Arthur Rizzo 110 points 

                                    -- mysql
ALTER TABLE `members` CHANGE COLUMN `full_names` `fullname` char(250) NOT NULL;

4 (9 Votes)
0
Are there any code examples left?
Find Add Code snippet
New code examples in category SQL
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
rename the database in mysql mysql for each return rename table name how to rename the table name in mysql how can we rename tabel in mysql mysql update table name update mysql table name how to modify column name in mysql RENAME COL IN MYSQL mysql to change column name alter changer name cloum forgien mysql mysql changer table name HOW TO ALTER NAME IN MYSQL rename column name in mysql using sql command mysql renaming table table name change in mysql mysql rename field in table renamign tables mysql rename mysql table in terminal rename columns mysql rename database table mysql how to rename table mysql mysql rename columbn mysql server cli to rename a database how to rename in table in mysql rename table from db mysql mysql alter rename database edit a column table mysql how to rename a table in mysql in terminal rename mysql database using sql statement mysql cli to rename table change column name in table mysql rename mysql query mysql sql modify table name mysql in rename tble how to rename column in mysql with as rename database mysql cli how to rename query tab in mysql how ro change table name mysql rename mysql table name rename database mysql command how can rename entries in mysql updating table name in mysql how to update the name of the table mysql how to change a table name in mysql rename db query mysql editing column name in mysql alter database rename mysql mysql alter database name alter edit table name manually without using mysql rename statement in mysql edit table name in mysql rename mysql db name rename in mysql will move the table alter column name mysql how to rename a column in mysql rename a column in mysql rename a mysql table column mysql rename columt changing table name in myslq mysql database rename rename mysql db how to change name of a table in mysql how to rename mysql database name rename mysql database name rename syntax in mysql; mysql how to change column name query to change table name in mysql how to change the name of a column in mysql change column name mysql query rename column name in mysql Query mysql alter change column name mysql rename table name with pattern mysql how to change name of column rename table query in mysql how to change the column name in mysql rename mysql column mysql rename field update column name in mysql rename column in mysql Query RENAME DATABASE mysql mysql database rename query modify column name in mysql alter tablename mysql mysql coloum rename mysqls rename column mysql rename function alter name column mysql change column name mysql rename table column name in mysql rename query result as mysql mysql rename whole query as mysql rename whole query rename table myql how to change a column name in mysql how to change column name in mysql mysql rename column in select rename a column mysql alter table rename column name in mysql alter table column name in mysql mysql alter column name mysql rename to mysql rename table query change column name in mysql how to alter table name in mysql to add a column alter change col name mysql mysql change name of column mysql change column name in query mysql edit colunn rename column name in mysql how to update field name table in mysql alter column name in mysql mysql update column name change name of a table in mysql mysql select as rename rename table mysql command how to change table name and type in mysql rename db mysql rename db mysql on cmd alter database mysql rename rename collums MySQL rename database mysql how to rename a temoprary table in mysql mysql field rename mysql change clomn name how to rename mysql table how to rename a mysql database rename mysql database command line mysql alter table chanfe column name change table column name in mysql rename database mysql command line rename a database mysql alter a column name in mysql mysql alter table rename change name table in mýql how change a table name in mysql rename column mysql how to update table name mysql update table name in mysql how to change the name column of mysql rename table columm mysql rename mysql database alter table rename mysql alter table rename column mysql mysql change column name as mysql change column name rename column alter table mysql rename alter table mysql rename query in mysql command change table field name in mysql how to change table names in mysql change name of a table mysql mysql rename column rename sql workbench table how to rename my from table in sql how to get table field names in mysql how to alter my sql database table name how to give constraint name in mysql how to change the name of database table in mysql how to change the name of the table in mysql mysql how to change name of table change the name of table in mysql raname table mysql rename db table mysql rename tebmle mysql mysql rename table column mysql modify table name mysql how to rename table renaming tables inside select statemen mysql renaming tables in select mysql chage table name mysql how to change table name in mysql workbench rename table name in ppmysql sql rename table mysql how to remame a table using mysql code myslq change table name mysql rename culomn rename a table mysql How to change the table name in MySQL? how to edit table name in mysql rename a table in my sql mysql rename yable table rename mysql table name rename in mysql rename table name mysql how to update table name in mysql phpmyadmin command to rename table command replace table name in mysql mysql workbench rename table change database name in mysql how can rename table name in mysql rename table if exists mysql mysql table rename table name as mysql mysql rename a table how to rename mysql dtable edit table name in sql workbench alter name of table mysql mysql renametable how to change the tablename in mysql mysql rename table name renaming table in mysql rename table mysql syntax mysql rename query name rename table name in my sql how to change the name of a table in mysql how to change name of table mysql sql query to rename table name in mysql alter table column name ,mysql how to change database table name in mysql how to rename a table name in mysql change table name with alter table mysql workbench modify a table name mysql change name of table in mysql RENAME a table sql mysql renaming tables mysql how to change name of item in my sql rename table command line how to change table name mysql mysql update tables which has name start by mysql change name table rename the database table name ranem table mysql alter table name in mysql reaname table mysql rename a table in mysql database rename the name of table in mysql mysql command rename table mysql change table name how to change table name in mysql command line mysql ubuntu rename table remane table changing taable name in mysql mysql rename values of table rename table mysql' how to reename a table mysql alter table name mysql changing table name in mysql query to rename table in mysql mysql alter table name How To Rename Table Using MySQL RENAME TABLE Statement mysql query for change the table name myhcl table rename raneming table mysql how to change name of table in my sql how to rename table in mysql how to rename a table in mysql UPDATE table name mysql rename table rename table in mysql command mysql rename tables change table name mysql sql to rename table in mysql how to change name of table in mysql change table name in mysql table rename in mysql how to rename table name in mysql how to make change in etity in mysql how can i rename an element in mysql rename query in mysql change the name of a table in mysql How to change the name of table mysql rename table mysql how to change table name in mysql rename table name in mysql is rename still works in mysql renaming a table in mysql change name table mysql table namechange in mysql rename mysql table mysql table name change mysql edit table name mysql change table title rename mysql rename table in mysql rename a table in mysql rename table mysql query mysql rename object key rename in mysql\ how to change the table name in mysql rename in mysql mysql RENAME changing table name mysql change the name of the table in mysql how to alter table name in mysql change table name using mysql change mysql table name mysql rename table alter rename command in mysql
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source