MySQL Rename Table
It is incredibly easy to rename a table in MySQL.
rename table table1 to table2;
Here is an example where we create a new database with a new table and then rename it. The original table name is ‘customers’. We rename this to ‘employees’.
create database test1; use test1 create table customers (fname VARCHAR(255), lname VARCHAR(255)); show tables; rename table customers to employees; show tables;