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
Sharad Chhetri is an experienced Linux, DevOps, Cloud Engineer & Freelancer. Working on various technologies since RHEL 4 era. He loves sharing the knowledge which he has earned from his experience.
You can contact him on email for freelance projects at admin@sharadchhetri.com.
In this tutorial we will learn about how to setup MySQL Master Slave replication in CentOS 6.4.In Master-Slave replication one database server (Master) can replicate the databases to one or more MySQL database Server(slave). The Slave server is not required to be connected always with Master Server, once slave server is up and when you…
MySQL server comes with many engines,earlier MyISAM was default storage engine but from MySQL version 5.5 and later InnoDB now become a default storage engine. Yet,you should know what is the default storage engine running in mysql server. It might be possible any database admin has changed to MyISAM or INNODB as default storage engine…
In this tutorial we will learn how to install MySQL Server 5.6 in CentOS 6.x and RHEL 6.x by using yum command. The package is “Architecture Independent” hence applicable to 32 bit(i386) and 64 bit(x86_64) operating system.Details of system where practical has been applied Operating System: CentOS 6.5Arch: x86_64 and i386 (Both) Install the MySQL…
In this tutorial we will learn about how to set default storage engine to MyISAM to InnoDB or vice versa. Since the change in MySQL default storage engine as InnoDB there are many Database Servers which are still running in MyISAM. The change in Default storage engine come after MySQL 5.0 and later versions. In…
How to configure multiple mysql instance in Ubuntu In this tutorial we will learn,how to configure multiple mysql instance in Ubuntu.Here multiple mysql instance means we can run multiple mysql server in single machine.We expect you have already install mysql-server in your system(if not then run the command apt-get install mysql-server). To configure multiple mysql…
