How to Change Table Name in MySQL

Introduction :-
If you want to change the Table name without loss you data then it's very simple to change the table in MySQL database and sql server database.

Description : -

To change the name of an existing table first to second, use this command as shown below

RENAME TABLE first TO second;

For Example

You have table name like stodent_tab
and there are four fields like First_name,Last_Name,Stud_ID,Stud_Batch
and you want to change the name of  stodent_tab because you have done mistake in student_tab name

So Query Like This

RENAME TABLE stodent_tab TO student_tab;

Note -: This query is same if you want to use the sql server database.




Use PhpMyAdmin You Can Change the Table Name Like This 

Step 1 :- Open phpmyadmin

Step 2 : - Select database and click on table which you want to change the name . Appear  this GUI as show below

Step 3 :- Check Rename table to and write the name of table which you want to give and click Go Button
Your table name is change Successful