FreeBSD - Tutorials, Security
Home   Archives   Sitemap   About   Contact

MySQL table - change or rename MySql table name

Home NEW! Unix Forum News 100 Tips and Tricks Website Development Server Operating Systems Databases
 Ivorde.ROarrow Databases arrowGeneral DevelopmentarrowMySQL table - change or rename MySql table name 

Article Sections

    Hello, Guest !
User name:
Password:
 
Google

 SSD VPS Hosting - Vpsie.com
 Mo.nitor.me
 Ivorde forum
 FreeBSD Tutorials
 Linux LVM Commands
 Free Shell Accounts
 FreeBSD Project
 FreeBSD Handbook
 Advanced Bash-Scripting Guide
 The OpenBSD Project
 Distrowatch
 FreeBSD Handbook


Apache Webserver Home Page

Posted on: 16 Feb 2008
Author: mandrei
Section: Databases | General Development
Views: 627
Comments: 3 (Add)

MySQL table - change or rename MySql table name
change mysql table name, change table name, mysql table, rename table, rename mysql table

 



Rename MySQL table - Change MySQL table name:

Database or website admin work sometimes asks for simple tasks like renaming a mysql table.

Say you have a mysql database named test and, inside it, you have the following 3 tables:

$ mysql -u root -ppassword test
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 11342
Server version: 5.0.45-log FreeBSD port: mysql-server-5.0.45_1

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| Table_test1 |
| Table_test2 |
| Table_test3 |
+----------------+
3 rows in set (0.00 sec)
mysql>

and you want to change the name of Table_test1's table into new_table. This is done by using using the mysql rename table syntax: RENAME TABLE old_table TO new_table

mysql> RENAME TABLE Table_test1 TO new_table;
Query OK, 0 rows affected (0.00 sec)

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| new_table |
| Table_test2 |
| Table_test3 |
+----------------+
3 rows in set (0.00 sec)

As you can see the query for changing the table's name was successful.

Rename more than one MySQL table

Renaming more than one Mysql table is very similar in structure to changing the name of only one table. This query looks like this:

RENAME TABLE this_table TO that_table, old_table TO this_table;

Bookmarks: Echo "MySQL table - change or rename MySql table name" around:
del.icio.usdiggFurlYahooMyWebGoogleBookmarksFaceBookTechnocratti
-------------------advertising-----------------

Other articles in Databases / General Development
» How to set up a password for root user in MySql
» Recover a lost MySQL root password
» How to copy a mysql database using mysqldump
» How to backup all mysql databases with one command
» How to calculate difference in days between two dates in MySQL




Contact webmaster regarding this article
Register or Login to post your article
Hello, Guest ! You can Login or Register to www.ivorde.ro!

 Post comment:

Name:
Title:
Comment:
Please type the word you see in the image (anti-spam verification). Refresh the page if you don't understand the word.
Allowed HTML Tags for comments:<p><strong><em><u><h1><h2><h3><h4><h5><h6><img><li>
<ol><ul><span><div><br><ins><del>

3 comment(s) to MySQL table - change or rename MySql table name:

1. Re: MySQL table - change or rename MySql table name
mysql select by Andrei at August 02nd, 2010 - 08:00
You can try:
SELECT fist_table.columnA AS something from first_table, second_table.columnA as something-else from second_table.... and so on.

2. Re: MySQL table - change or rename MySql table name
Tabels , name changing by Arash at August 02nd, 2010 - 03:54

I have 2 questions :

1. Suppose we have 20 tables which all of them have got the same columns (the number of the columns and the name of the columns are all same ). How can I combine and convert all of them into a single Table.

2. Imagine we have the same case as explained above( 20 tables with same columns ), so we want to change the name of each tables to the same name which is in first row of Third column of each table.

any one have got some codes or solution for that ?

Thx

3. Re: MySQL table - change or rename MySql table name
a by a at April 23rd, 2008 - 08:20
a

   Latest topics on the forum:
 
   Most viewed articles:
How to copy a mysql database using mysqldump - 9376 views
How to change a user's password in AIX with the output from ECHO command - 8635 views
FreeBSD: Add/remove an additional IP alias - 5609 views
Qmail relay to smarthost: How to route all mail to a smarthost - 3929 views
Print queues in AIX 5L - How to list print queues in AIX - 2885 views

   Latest 10 articles:
Qmail relay to smarthost: How to route all mail to a smarthost - 03 Feb 2009
EXIM 4 relay to smarthost: How to route all mail except local domain - 03 Feb 2009
Windows XP: print LISTEN ports and network connections using netstat - 30 Jan 2009
How to cut out first last n characters from each file name, from a filelist - 04 Nov 2008
Mozilla Firefox3 is now released - 18 Jun 2008
How to switch lower case to upper case and upper case to lower case in a string - 17 Jun 2008
How to rename files/directories to uppercase/lowercase character names - 17 Jun 2008
How to convert lower case to upper case letters in a shell script/command - 17 Jun 2008
Unix,Linux,FreeBSD - How to rename a list of files, replacing spaces inside their names - 12 Jun 2008
How to change a user's password in AIX with the output from ECHO command - 21 May 2008


Archives
» 2007  |  June  |  October  |  November  |  December
» 2008  |  January  |  February  |  March  |  April  |  May  |  June  |  November
» 2009  |  January  |  February



Home | Archives | Sitemap | About | Contact

Designed and developed by Andrei Manescu. Optimized for Mozilla Firefox.  
Copyright 2007 Andrei Manescu
All trademarks and copyrights on this page are owned by their respective owners. Comments are owned by those who posted them.
Valid W3 Document Valid XHTML 1.0 Transitional Valid CSS! The FreeBSD Project Viewable With Any Browser