Rename a MySQL table

Tyler Tyler (285)
0
Updated: February 18th, 2015

Renaming a MySQL table is very simple, but sometimes the syntax is hard to remember.

Posted in these interests:

webdev
PRIMARY
58 guides
mysql
9 guides

Rename a MySQL table

webdevmysql
Tyler Tyler (285)
0
Updated: February 18th, 2015
Tyler
1
 

Posted in these interests:

webdev
PRIMARY
58 guides
mysql
9 guides
webdev
PRIMARY
58 guides
mysql
9 guides
PRIMARY
Calling all writers!

We’re hiring. Write for Howchoo

1
 
In these interests
webdev
PRIMARY
58 guides
mysql
9 guides
webdev
PRIMARY
58 guides
mysql
9 guides
PRIMARY

In the MySQL prompt type: use database_name

Now type: RENAME TABLE old_table_name TO new_table_name;

In the MySQL prompt type: use database_name

In the MySQL prompt type: use database_name

Select the database

Now type: RENAME TABLE old_table_name TO new_table_name;

Now type: RENAME TABLE old_table_name TO new_table_name;

Rename the table

Calling all writers!

We’re hiring. Write for Howchoo

Tyler's profile pictureTyler
Joined in 2015
Software Engineer and creator of howchoo.
Tyler's profile picture
Share this guide!
RedditEmailText
Related to this guide:
MySQL vs PostgreSQLMySQL vs PostgreSQL
Comparing performance, syntax, replication, and features.
Gilad's profile picture GiladView
In these interests: postgresqlwebdevmysql
How to export clean HTML from Google DocsHow to export clean HTML from Google Docs
By default, the HTML exported from Google Docs includes tons of classes, styles, and is generally messy. This short guide will teach you how to export clean HTML devoid of classes and inline styles.
Zach's profile picture ZachView
In these interests: googledocswebdevcode
Filtering Google Analytics language spamFiltering Google Analytics language spam
Google Analytics spam is nothing new. But now spammers have realized that, since language appears in the initial Google Analytics dashboard view, spoofing the language code reaches eyeballs.
Zach's profile picture ZachView
In these interests: webdev
MySQL vs PostgreSQLMySQL vs PostgreSQL
Comparing performance, syntax, replication, and features.
Gilad's profile picture GiladView
In these interests: postgresqlwebdevmysql
Gilad's profile pictureViewpostgresqlwebdevmysql
How to export clean HTML from Google DocsHow to export clean HTML from Google Docs
By default, the HTML exported from Google Docs includes tons of classes, styles, and is generally messy. This short guide will teach you how to export clean HTML devoid of classes and inline styles.
Zach's profile picture ZachView
In these interests: googledocswebdevcode
Zach's profile pictureViewgoogledocswebdevcode
Filtering Google Analytics language spamFiltering Google Analytics language spam
Google Analytics spam is nothing new. But now spammers have realized that, since language appears in the initial Google Analytics dashboard view, spoofing the language code reaches eyeballs.
Zach's profile picture ZachView
In these interests: webdev
Zach's profile pictureViewwebdev
People also read:
Converting XML files to JSON is a good practice for providing easy manipulation and preparing service responses. You can accomplish this efficiently with just three lines of code.
Part of being a web developer is testing things that will inevitably break in insane and unexpected ways in Internet Explorer.
As a developer, I’ve customized my bash prompt to always show the current git branch if I’m in an initialized git repository. This is convenient, but it can make for a very long bash prompt.
This guide will show you how to set up a LAMP environment in macOS and OS X.
I’ll spoil it – “printenv” is your friend. This guide will show a few examples of how to use it.
Surprisingly, normal YouTube embeds are not automatically sized to the browser window as it is resized.
I started programming in PHP, so by default I would use apache even when I just wanted to test basic HTML files. As I was learning Python, I discovered a great HTTP request handler.
As a web developer, I stare at Chrome’s developer tools — particularly the Elements and Console tabs — all day long. As a result, all light and no dark makes Zach’s eyes dull and tired.
You can echo the current MODX resource’s full page URL without the use of a snippet call.
Converting XML files to JSON is a good practice for providing easy manipulation and preparing service responses. You can accomplish this efficiently with just three lines of code.
Part of being a web developer is testing things that will inevitably break in insane and unexpected ways in Internet Explorer.
As a developer, I’ve customized my bash prompt to always show the current git branch if I’m in an initialized git repository. This is convenient, but it can make for a very long bash prompt.
This guide will show you how to set up a LAMP environment in macOS and OS X.
I’ll spoil it – “printenv” is your friend. This guide will show a few examples of how to use it.
How to Convert XML to JSON in PHP
How to Run Internet Explorer on Mac (For Free)
Adjust the Length of Your Bash Prompt on the Fly
How to Set Up a LAMP server in macOS
How to Print Environment Variables in Linux/Unix
Surprisingly, normal YouTube embeds are not automatically sized to the browser window as it is resized.
I started programming in PHP, so by default I would use apache even when I just wanted to test basic HTML files. As I was learning Python, I discovered a great HTTP request handler.
As a web developer, I stare at Chrome’s developer tools — particularly the Elements and Console tabs — all day long. As a result, all light and no dark makes Zach’s eyes dull and tired.
You can echo the current MODX resource’s full page URL without the use of a snippet call.
GitHub Pull Requests: How and Why to Use Pull Requests
Make YouTube Video Embeds Responsive Using Pure HTML and CSS
Using Python’s simple HTTP server
Tell Chrome Developer Tools to Use a Dark Theme
How to Print the Current Page URL in MODX
Posted in these interests:
webdevwebdev
webdev
PRIMARY
All things web development.
webdevwebdev
webdev
PRIMARY
All things web development.
PRIMARY
ExploreExplore
Discuss this guide:
We’re hiring!
Are you a passionate writer? We want to hear from you!
We’re hiring!
Are you a passionate writer? We want to hear from you!
View openings

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Donate

Leave a Reply

Your email address will not be published. Required fields are marked *