MySQL Rename Table

It is incredibly easy to rename a table in MySQL.

Quick Answer:

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; 

Video Guide