How to Rename Table in MySQL Query

How to rename table in mysql query - If previously I have explained about how to alter table structure. So in this post I will share how to change the table name. For those of you who do not know how to change the table name then check out the explanation from me in this post.
Before starting this tutorial you should first learn the following tutorial:
To rename a table, can use the following SQL commands:
RENAME TABLE student TO college_student;
To change the table other than using the code can also use alter command.
ALTER TABLE student RENAME TO college_student;
The above command will change the table student  become a college_student.
The following is the result of a practice example of applying the sql command to rename the table.
How To Rename Table in MySQL Query
How To Rename Table in MySQL Query

That's a pretty brief explanation from me about "how to rename table in mysql query". Hopefully the explanation of the blog "php programming language" above can increase our knowledge in studying mysql database.

Comments