Renaming MySQL Tables

Licensed Scripts

Licensed Scripts

HTML Tutorials	CSS Tutorials
Photoshop Tutorials	Flash Tutorials
JavaScript Tutorials	Jquery Tutorials
JSP Topics	Php Tutorials
MYSQL Tutorials	Regular Expression
Perl Tutorial	Domain & Dns
Unix Commands	C++
Vista Services	Linux Services
Web Building	Seo Tutorial
Powerpoint	VB.Net Tutorial
Rss Feed

Clipart Pictures

Signs

Country Emblems

Background Images

Logos

Menu Builder	Button Creator
Link Analyzer	DNS Lookup
Website Popularity	Color Chooser
Apache Ver Lookup	Page Rank Checker
Case Converter	Form Generator
Statistics	Epoch-GMT Converter
Hours Calculator	Htpasswd Generator
Favicon Generator	Backlink Checker
Image Crop Tool	Chart and Graph Tools
Multiple Drop Down Menu	Email Verification Tool
If Modified Since	Language Subtags

MySQL Tutorial

Portuguese

Outsource Servers

Online Calculator

Hosting Companies

Home

Home

Scripts

Scripts

Tutorials

Tutorials

Images

Images

Tools

Tools

Purchase

Purchase

Snippets

Snippets

Mysql Tutorial

How to Install

Database

Datatypes

Tables

INSERT

SELECT

Operators

Functions

Ask Your Doubts

track, manage link submission status

Renaming Mysql Tables

Topic

How to rename a Mysql table?

Explanation

Rename MySQL tables :

The RENAME statement is used to rename one or more tables in a database.
The syntax is

RENAME TABLE tbl_name TO new_tbl_name
    [, tbl_name2 TO new_tbl_name2] ...

The below renaming mysql tables query renames the student table as class table.

mysql> rename table student to class;
Query OK, 0 rows affected (0.00 sec)

Now we can view the table whether the name is changed by the following query.

mysql> show tables;
+--------------------+
| Tables_in_sample   |
+--------------------+       
| class              |                 
+--------------------+
1 row in set (0.00 sec)

If the query renames more than one table, renaming operations are done from left to right.

We can also swap two table names. Let us assume tmp table which does not exists.

Example :

RENAME TABLE emp1 TO tmp,
             emp2 TO emp1,
             tmp TO emp2;

We can also use RENAME TABLE to move a table from one database to another.

Example :

RENAME TABLE current_db.tbl_name TO other_db.tbl_name;

A Note

MySQL is the most popular open source Relational database Management system (RDBMS). Being a open source anyone can use and change the software for their needs. Hope you enjoy this tutorial. We welcome your Valuable feedbacks or suggestions on this MySQL tutorial. This is a copyright content.

Other Links

web hosting