How to rename table in mysql using command line

by

In this post we will know how to rename table in mysql using command line. It is basic and important command for MySQL database administration. We are doing this practical in MySQL server version 5.5.29.

Syntax:

Replace the table_name and NEW_TABLE_NAME as per your requirement.

ALTER TABLE table_name RENAME NEW_TABLE_NAME

Example: See the below given screenshot

Red Color arrow represents OLD table name
Blue Color arrow represent NEW table name

mysql

Related posts:

  1. mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed
  2. How to copy existing table in mysql
  3. How to know storage engine of mysql table
  4. How to rename and move the directory and files in linux
  5. Find mysql commands history without mysql server login
  6. See mysql command output vertically
  7. How to change mysql default data directory in Ubuntu
  8. Install MySQL workbench in Ubuntu
  9. Setup MySQL master slave replication in CentOS 6
  10. How to configure multiple mysql instance in Ubuntu

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.