MySQL

295 guides

keyboard_arrow_down

Other math topics

Dagster

Pandas

NumPy

Matplotlib

PySpark

MySQL

chevron_leftGeneral table Cookbook

Showing all the fields of a table Deleting a table Showing all tables Creating a table Cloning a table Finding all tables with a specific column name Removing a temporary table Renaming a table Creating a temporary table Restoring a table from an sql file Backing up a table

check_circle

Mark as learned

thumb_up

thumb_down

chat_bubble_outline

Comment

auto_stories Bi-column layout

settings

Renaming a table in MySQL

schedule Aug 10, 2023

Last updated

local_offer

MySQL

Tags

tocTable of Contents

expand_more

Example

mode_heat

Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!

In MySQL It is possible to rename a table using the following:


        
        
            
                
                
                    ALTER TABLE old_name RENAME new_name;

Alternatively you can use the following:


        
        
            
                
                
                    RENAME TABLE old_name TO new_name;

Example

To rename the table info to changed_info:


        
        
            
                
                
                    ALTER TABLE info RENAME changed_info;
                
            
            Query OK, 0 rows affected (0.01 sec)

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!