MySQL Rename Table

Quick Answer: rename table table1 to table2; Example: create database test1; use test1 create table customers (fname VARCHAR(255), lname VARCHAR(255)); show tables; rename table customers to employees; show tables;