Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides

FAQ

It is currently Sun Dec 10, 2023 5:49 am

ROOT ‹ Website Development and Databases ‹ Mysql ‹ Rename MySql table

Mysql Application & Query Optimization, Questions, Indexes, Bugs.

Post a reply

2 posts • Page 1 of 1

Rename MySql table

« Previous topic | Next topic »

Author

Message

debuser

Post subject: Rename MySql table | Posted: Sun Aug 22, 2010 5:46 am

Joined: Thu Aug 06, 2009 2:48 am
Posts: 105

Rename MySql table

To rename a mysql table, just use the rename mysql command

Code:

mysql> RENAME TABLE old_name TO new_name;

			Tweet
Follow @IvordeCom

You might also be interested in:
MySql rename table. Mysql: add column to table. Mysql add Unique index to a table column. Mysql remove column from an existing table. MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13). How to use a mysql stored procedure. Mysql: Cleaning binary logs. Mysql change column's default value. Mysql drop (remove) unique key. Mysql change root password.

Top

sonee4

Post subject: Re: Rename MySql table | Posted: Fri Oct 08, 2010 1:36 am

Joined: Thu Oct 07, 2010 11:25 pm
Posts: 3

you may just click the rename command in your command box and give the new name and then it will change to your preffered name.

Top

Post a reply

2 posts • Page 1 of 1

Topics		Author	Replies	Views	Last post
Topics related to - "Rename MySql table"
	MySql rename table	admin	2	2857	Mon Nov 28, 2011 3:39 am Darwin
	Mysql: add column to table	debuser	1	4266	Fri Oct 08, 2010 1:38 am sonee4
	Mysql add Unique index to a table column	debuser	0	3306	Fri Aug 06, 2010 10:01 am debuser
	Mysql remove column from an existing table	debuser	0	2338	Fri Aug 06, 2010 10:06 am debuser
	MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)	debuser	0	3220	Mon Feb 22, 2010 1:43 pm debuser
	How to use a mysql stored procedure	debuser	1	2350	Tue Nov 22, 2011 1:23 am Darwin
	Mysql: Cleaning binary logs	debuser	1	2772	Tue May 18, 2010 9:45 am designeru
	Mysql change column's default value	debuser	0	2794	Thu Aug 12, 2010 3:43 am debuser
	Mysql drop (remove) unique key	mandrei99	0	2723	Wed Jan 14, 2015 7:53 pm mandrei99
	Mysql change root password	mandrei99	0	2952	Tue Feb 10, 2015 6:50 pm mandrei99

Who is online

Users browsing this forum: No registered users and 0 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:

Channel list

ROOT ‹ Website Development and Databases ‹ Mysql

Delete all board cookies | The team | All times are UTC - 5 hours [ DST ]