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

 SATELLITE INTERNET
 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

Blog, intrebari si raspunsuri despre Leasing

Posted on: 17 Feb 2008
Author: mandrei
Section: Databases | General Development
Views: 888
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
DNS query tools - Network tools Ping - Traceroute 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>

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 - 15: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 - 10: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 - 15:20
a

   Latest topics on the forum:
ffmpeg: error while loading shared libraries: libavdevice.so.52: cannot open shared object file: No
FFMPEG svn 24953 compile fails videodev.h:56: error: expected specifier-qualifier-list before ‘ulong
Apache to Nginx Server parameters translation with php function
Rename MySql table
Mysql - Change position of a column after another column
Mysql change column's default value
Postfix change message size limit
Pool for spam
Mysql remove column from an existing table
Mysql add Unique index to a table column
 
   Most viewed articles:
How to remove first/last character from a string using SED - 8514 views
Reloading /etc/profile - how to reload Unix /etc/profile - 5763 views
How to clear/reset DNS cache on Windows XP / Linux - 5308 views
How to check if an rpm package is installed on a Red Hat Linux server - 4000 views
FreeBSD: Add/remove an additional IP alias - 3838 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