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

 FreeBSD Tutorials
 Linux LVM Commands
 Free Shell Accounts
 FreeBSD Project
 FreeBSD Handbook
 The OpenBSD Project
 Distrowatch
 FreeBSD Handbook


Apache Webserver Home Page

Blog, intrebari si raspunsuri despre Leasing

Posted on: 17 Feb 2008
Author: mandrei
Section: Databases | General Development
Views: 2466
Comments: 1 (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 backup all mysql databases with one command
» How to copy a mysql database using mysqldump
» 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.
Verification code
Allowed HTML Tags for comments:<p><strong><em><u><h1><h2><h3><h4><h5><h6><img><li>
<ol><ul><span><div><br><ins><del>

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

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

   Latest topics on the forum:
Openssl: Commandline base64 string encoding
Using echo, netcat(nc) and tr to create an HTTP connection
Unix shell - using TR to replace new lines with spaces
SED how to remove multiple white spaces from a string
Starting nginx: [emerg]: directive "rewrite" is not terminated by ";"
Converting PhpBB-SEO Apache RewriteRule to Nginx rewrite
MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
/usr/bin/ld: cannot find -lltdl PHP Compiling fails on Centos/Red Hat
How to install apache22 on FreeBSD with proxy modules
Windows XP Microphone volume drops unexpectedly / auto adjusts to low value
 
   Most viewed articles:
How to clear/reset DNS cache on Windows XP / Linux - 15020 views
How to remove first/last character from a string using SED - 14632 views
Reloading /etc/profile - how to reload Unix /etc/profile - 11820 views
Substitute strings in files with perl, sed or vi(m) - 11000 views
How to change a user's password in AIX with the output from ECHO command - 7684 views

   Latest 10 articles:
FreeBSD - Collect installed hard disk drive information - 19 Mar 2009
Set up FTP PROXY via command line in Linux/FreeBSD - 19 Mar 2009
Set up HTTP PROXY via command line in Linux/FreeBSD - 19 Mar 2009
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
qmail qmail-scanner/clamav qmail-inject: fatal: qq temporary problem / clamdscan: corrupt or unknown clamd scanner error or memory/resource/perms problem - exit status 512/2 - 05 Dec 2008
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


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



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