Rename a column

sql

ALTER TABLE users CHANGE COLUMN full_name display_name VARCHAR(255) NOT NULL;

Explanation

In MySQL, `CHANGE COLUMN` renames a column and requires the new full definition.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing create and alter tables

Add a nullable column to an existing table.

Open In sheetsqlsame section

Change type, size, or nullability.

Open In sheetsqlsame section

Remove a column from a table.

Open In sheetsqlsame section

Create a schema if it does not already exist.

Open In sheetsqlsame section

Create a table with an auto-increment primary key and timestamps.

Open In sheetsqlsame section

Rename a table without recreating it.

Open In sheetsqlsame section