MySQL – Rename a column from the table

Would you like to learn how to rename a column from an existing table? In this tutorial, we are going to show you how to use the MySQL command-line to change the name of a column from the table.

• Ubuntu 20.04
• Ubuntu 19.04
• Ubuntu 18.04
• MySQL 8.0.19

Equipment list

The following section presents the list of equipment used to create this tutorial.

As an Amazon Associate, I earn from qualifying purchases.

Related tutorial – MySQL

On this page, we offer quick access to a list of tutorials related to MySQL.

Tutorial MySQL – Rename a column from the table

Access the MySQL command-line.

Access the MySQL database.

Describe the MySQL table.

Here is the command output:

Rename a column from the MySQL table.

In our example, we rename the column named REG_DATA to D_CREATION.

Congratulations! You are able to rename a column from a MySQL table.