How to Rename a Column in MySQL

This example renames the column my_column to my_renamed_column:

ALTER TABLE my_table
RENAME COLUMN my_column TO my_renamed_column;
Previous
How to Drop a Column in MySQL
Next
Composite Primary Keys in MySQL

Get started with DB Pilot

DB Pilot is a Database GUI client and SQL editor for PostgreSQL, MySQL, SQLite, DuckDB & more.

Download Learn more