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.
This is a small tip to find mysql commands history without login into mysql server.When we login into MySQL server,generally we uses up and down arrow key to find the history of MySQL commands. Actually the MySQL commands history are saved in file called .mysql_history located in user’s home directory by which he/she logged into…
In this practical we will learn, how to install mysql server 5.6 on Ubuntu 14.04 LTS ( Trusty Tahr ).At the time of writing this post, MySQL Server has 5.6 version as stable release (release date – 11 April 2014). MySQL is a open source relational database management system (RDBMS). It is popularly used in…
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 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…
When you work on mysql server and hit some command in mysql prompt,you get the output in horizontal way. For eg. I hit the command, select emailid from linuxtable where user = ‘sharad’; and this table has lots of fields . In that case the output looks weird. Rather than seeing the output Horizontally in…
In this post we will learn about how to copy the existing table in mysql. The newly copied table does not have data means it will be blank but it has similar rows information from its parent table. After copying the table you have to insert the data by using INSERT command. Follow the given…