• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
sharadchhetri

sharadchhetri

Tutorials On Linux, Unix & Open Source

  • Home
  • Linux Commands
  • Resources
    • Learn Linux
  • My WordPress plugins

How to rename table in mysql using command line

November 12, 2013 by Sharad Chhetri Leave a Comment

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

Share this:

  • Twitter
  • Facebook
  • More
  • Print
  • Email
  • LinkedIn
  • Reddit
  • Tumblr
  • Pinterest
  • Pocket
  • Telegram
  • WhatsApp
  • Mastodon

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

Filed Under: mysql Tagged With: mysql

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

Primary Sidebar

Our Social Media Presence

  • Facebook
  • GitHub
  • Twitter

Linux Command

What is Linux Internal And External Command

Linux Basic Commands With Examples For Every Beginner

tr command to convert lines to space , tab and vertical tab

smbpasswd command not found on CentOS 7 and RHEL 7

Solution : semanage command not found

Unix / Linux : How to print duplicate lines from file

More Posts from this Category

You Might Like These Articles!

simplecodesyntax wordpress plugin

SimpleCodeSyntax : My Another WordPress Plugin

Install Nginx

How To Install Nginx On Ubuntu 22.04 LTS

Install Latest Git package in Ubuntu Operating System

How To Always Install Latest Git Package In Ubuntu Operating System

Bash script for installing VirtualBox on Ubuntu 22.04 LTS Desktop

Install VirtualBox On Ubuntu 22.04 LTS Desktop (Bash Script)

libfuse

dlopen(): error loading libfuse.so.2 – Got Error On Ubuntu

Failed to open/create the internal network

VirtualBox Error: Failed to open/create the internal network

Always Useful Tips And Tricks

How to change login banner message in GUI mode in CentOS 6 or above version.

rsync all files,hidden files,symlinks,hardlinks to remotes Linux Server

How to put slider shortcode only in home page in WordPress

This kernel requires an x86-64 CPU but only detected an i686 CPU

Allow wget and yum in iptable

How to find swap partition or file in linux

master admin password openerp 7.x

Explore 90+ Article On "Linux Tips And Tricks"

Copyright © 2023 ยท
The material in this site cannot be republished either online or offline, without our permission.
Proudly Blogging From Bharat.

  • Contact
  • About Me
  • My WordPress plugins
  • Privacy Policy